Creating a fixed date range that dynamically updates every week | XM Community
Skip to main content

Creating a fixed date range that dynamically updates every week

  • February 16, 2023
  • 1 reply
  • 219 views
K

I'm very much a beginner with piped text and JavaScript so this may be pretty simple, but I'm trying to create a fixed date range for a two week period that updates every week.
I send this survey out on Wednesdays so I would like for it to show the coming Sunday to the following week's Saturday. For example 2/19/23-3/4/23. I've tried using the other date piped text (${date://OtherDate/SL/+3%20day} - ${date://OtherDate/SL/+16%20day}), which kind of works, but only if responses come in on Wednesday, otherwise it updates the date fields to be the incorrect dates. What should I do to make this work?

Nikkki

1 reply

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+46
  • Deepak
  • February 16, 2023

https://community.qualtrics.com/XMcommunity/discussion/24026/creating-a-fixed-date-range-that-dynamically-updates-every-weekYour approach is correct you will just have to replicate it for different weekdays. Firstly identify the weekday and then include the branch of the date logic.
Hope it helps!

Terms & ConditionsAccessibility statement