I am creating a survey which requires users to specify the start date of a programme on the first page, then populate 4 matrix tables with a value for each of the following 28 days. I am trying to make the scale points on each table dates generated on the basis of the user's original entry value (+1, +2... +28). Not sure how to get qualtrics to recognise the original entry as a date (rather than just text) so I can perform this addition. I have come across a problem of a somewhat similar nature in the support pages where the person asking the question was directed toward 'moment.js' but details were sparse and I couldn't quite get my head round how to integrate this. I'd be grateful for any help or suggestions.

Hi @sumwonels,there are more ways how to do this. Here is one of them:1) Create an HTML element with an ID in each label of a row in your matrix. Start with this one `<div id = "d0">0</div>` and then increase both numbers by one in each following line.2) Compute the last date and then get all dates between the start date and the end date using this function from GitHub.3) Convert your dates into the correct format and put these values into your HTML elements.So the whole code could look somehow like this: Qualtrics.SurveyEngine.addOnload(function() { function stringToDate(_date,_format,_delimiter) { var formatLowerCase=_format.toLowerCase(); var formatItems=formatLowerCase.split(_delimiter); var dateItems=_date.split(_delimiter); var monthIndex=formatItems.indexOf("mm"); var dayIndex=formatItems.indexOf("dd"); var yearIndex=formatItems.indexOf("yyyy"); var month=parseInt(dateItems[monthIndex]); month-=1; var formatedDate = new Date(dateItems[yearIndex],month,dateItems[dayIndex]); return formatedDate; } var getDates = function(startDate, endDate) { var dates = [], currentDate = startDate, addDays = function(days) { var date = new Date(this.valueOf()); date.setDate(date.getDate() + days); return date; }; while (currentDate <= endDate) { dates.push(currentDate); currentDate = addDays.call(currentDate, 1); } return dates; }; var start = stringToDate("${q://QID10/ChoiceTextEntryValue}","dd/MM/yyyy","/"); var end = new Date(); end = end.setDate(start.getDate() + 2); var dates = getDates(start, end); var i; var final_date; for (i = 0; i < dates.length; i++) {//temp = dates[i].getUTCDay() + ". " + (dates[i].getUTCMonth() + 1) +". "+ dates[i].getUTCFullYear(); //temp = dates[i][2]+'/'+ dates[i][1]+'/'+ dates[i][0]; var final_date = dates[i].getDate()+". "+(dates[i].getMonth()+1)+". "+dates[i].getFullYear(); document.getElementById("d"+i).innerHTML = final_date;} }); Note: Don't forget to change the ID of the question to yours and the end date to correct one.

Hi @sumwonels,I found a nice function which can convert text to Date on StackOverflow: function stringToDate(_date,_format,_delimiter) { var formatLowerCase=_format.toLowerCase(); var formatItems=formatLowerCase.split(_delimiter); var dateItems=_date.split(_delimiter); var monthIndex=formatItems.indexOf("mm"); var dayIndex=formatItems.indexOf("dd"); var yearIndex=formatItems.indexOf("yyyy"); var month=parseInt(dateItems[monthIndex]); month-=1; var formatedDate = new Date(dateItems[yearIndex],month,dateItems[dayIndex]); return formatedDate; } var start = stringToDate("17/9/2014","dd/MM/yyyy","/");Use content validation to ensure your date will be always in the correct format.And one more tip: it might be the most user-friendly if you combine the validation with a date picker. You can find the code for this here. Just replace dashes with slashes in the right places.

Generating dates into the future on the basis of a user-entered value

Generating dates into the future on the basis of a user-entered value | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded