Need to calculate the date difference to use in question piping

Question

I have a survey where, depending on whether someone has responded to a block before and whether 365 days have passed since then, they should either skip it or see it. I’m using a directory for authentication and saving the last completion date as MM_LastSurveyDate to compare with current date. MM_LastSurveyDate = empty → in the beginning of survey flowMM_LastSurveyDate = ${date://CurrentDate/Y%2Fm%2Fd} → when they complete that survey and it is recorded in the directory. This embedded field exists after the block in question is completed so it updates in the directory. The set up for the update is already done and working. I’m struggling to set up the 365-day condition, because I don’t know how to calculate the difference between two dates and how to add it into the survey flow. For more context, I haven’t used JavaScript before, so I have no idea what I’m doing. I tried to set this up in the survey flow with embedded fields, but had absolutely no luck. Heeelp pleaseee

sbd1989 · Accepted Answer

Update: solved.

sbd1989 · Answer

UPDATE: SolvedJust in case it helps someone else…..I’ve solved this with adding this code to the first question on the questionnaire:Qualtrics.SurveyEngine.addOnPageSubmit(function() {    var lastDateStr = "${e://Field/MM_LastSurveyDate}";    if (lastDateStr && lastDateStr.trim() !== "") {        var parts = lastDateStr.split('/');        var lastDate = new Date(parts[0], parts[1]-1, parts[2]);        var today = new Date();        var diffTime = today - lastDate;        var diffDays = Math.floor(diffTime / (1000 * 60 * 60 * 24));        Qualtrics.SurveyEngine.setEmbeddedData('__js_DaysSinceLastSurvey', diffDays);        console.log("Days since last survey: " + diffDays);    } else {        Qualtrics.SurveyEngine.setEmbeddedData('__js_DaysSinceLastSurvey', 9999);        console.log("No last survey date found. Setting to 9999.");    }});and adding the embedded field__js_DaysSinceLastSurvey in the beginning of the survey flow along withMM_LastSurveyDate

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded