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?