I am using Survey123 for inspections. They inspections are completed monthly and I have created the report as a Word document to print the inspection. I have been using this data and information all year. I have in my data 6 dates. The date is correct in Survey123; however when I generate the report, the date shows up as 1 day earlier for October but not November. (Example data entered as October 9 but shows up as October 8.) This error did not occur last month. Any ideas?
Hi Ginger,
That could be a solution; there are a couple of others.
For already collected data, you could either re-calculate the answer with +1 hour or create an Arcade Expression to do the same in a 'calculated' column.
To ensure new data is collected correctly, for datetime questions you could change the today() function to the following calculation:
decimal-date-time(today()) + (1 div 24)
This won't work for date questions, however