Hello!
I have created a survey that utilizes week numbers in some of it's calculations. I'm using a "calculate" field like:
| format-date(${SurveyDate}, '%W') |
Where "SurveyDate" is simply a date field captured separately.
%W should return a week number from a given date, however it returns an error like this:
The workaround as described here in 2018. Describes the fix as: just use a different format mask, I like %M and THEN save the XLSForm. Then in the raw XML for the form update the %Ms to %Ws as desired before publishing.
At the moment I'm in Survey123 connect 3.16, and I'm STILL dealing with this bug. I know the workaround is easy enough, but it's frustrating and does at times lead to mistakes. I just got done fixing some submissions because I published a survey update and forgot to break, then unbreak my survey via raw XML before publishing and they had incorrect week numbers.
Seeing this bug fixed would be very much appreciated.
Thank you!
