Survey Flow - Date Comparision | XM Community
Skip to main content

Hi all - 

 

I am working on a survey for which I’ve added an expiration date in the embedded data. Due to nuances in the process, I cannot use a link expiration is lieu of a completion date because respondents could in theory resume partial responses and complete after the deadline. (Though a link expiration does exist).

  • The “Complete By Date” is pulled from the URL. (format e.g. 9/7/2023)
  • The branch logic checks if “Complete By Date” is less than ${date://CurrentDate/SL} (format e.g. 9/5/2023). If this is true, then they are routed to the end of the survey. Otherwise, respondents can complete the survey.

We have successfully recorded responses previously, but this week the branch logic is not performing as expected. Respondents who have a survey deadline of 9/12/2023 are being branched to the end of the survey (as of 9/5).

 

Was there an update to Qualtrics logic that is now causing this issue? Am I missing something obvious in the logic?

@jmcintosh Date format might messed-up when doing comparison.
If you save your current date as an embedded data number 

currentDate = ${date://CurrentDate/Y}${date://CurrentDate/m}${date://CurrentDate/d}

e.g currentDate = 20230905

Complete By Date as the same format (20230912). You date will be treated as number and will be compare from digit to digit, from year to month to day and can never go wrong.
Let me know if it helps.

Hi Nam,

 

Thanks for your potential solution! I’ve updated the “current date” format to begin with the year and to have leading zeros, which seems to have resolved the issue. Not sure why it worked for 3 weeks and then had an error but this is working for now.

Leave a Reply


Terms & Conditions