Submission time is not in the same format as Start and End time

Support
1

1. What is the problem? Be very detailed.
Start and End times are in the correct format, and excel can easily change them to Date,Time+Timezone format.
But the submission times are always in GMT and Excel is not able to change it because they are in a different format.

2. What app or server are you using and on what device and operating system? Include version numbers.

3. What you have you tried to fix the problem?
I can add the timezone manually to GMT to get the correct time, but it's a workaround to a bug.

4. What steps can we take to reproduce the problem?
Make any submission and check the excel file.
Start and End times are written like this: 2019-11-21T10:32:27.405+04:00
Submission times are written like this: 2019-11-21T15:23:05

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

2

Hi,

The reason for this is that start and end time are created by the mobile device so the format and timezone depend on the device settings. Submission date/time is created by ODK Aggregate or whichever online server you use which is why it defaults to GMT.

Unfortunately its not really a bug as the server needs to have one default timezone. Can you maybe explain why this is causing problems for you and maybe it will be possible to suggest a workaround?

1 Like
3

Thanks for the reply; that makes a lot of sense.
The issue is that I use Powerquery in Excel to format the data, and for Start and End times it works perfectly when I set the data type to "Date/Time/Timezone" but for the submission time field, it always shows GMT no matter which data type I select.