Completed

:speech_balloon:

More user friendly date format in export

I was wondering why the date format when I export the data (Andoid app) is written in a format that is not easy to process: 20th Mar 2021

Excel does not register this as a date format when I use it, so I cannot easily convert the data to international format (2021-03-20) so that I can compare my symptom data to another dataset related to pollution levels and bushfires that I wanted to correlate. The shared feature would have been date but as they do not share a date format, I cannot do this.

Could this please be changed in the future to make date formating easier?

5 votes

Tagged as Suggestion

Suggested 22 May 2021 by user James Lloyd

Moved into Completed 01 December 2022

  • Sign in to comment. Sign in by email

  • 22 May 2021 James Lloyd suggested this task

  • 23 May 2021 James @Bearable approved this task

  • avatar
    Sean L

    I can’t imagine how the dates ended up like this in the first place; the actual app data can’t be stored this way. Even in SQL Server this format is a huge pain to parse into an actual date value, and getting a date value into this format would require extra work.

    There are plenty of “readable” date formats that can be easily converted in Excel, SQL, etc… Why go out of the way to use this bizarre one?

    18 November 2021

  • 01 December 2022 Eoghan moved this task into Completed