Issue with date formats when data downloaded as CSV

  • Profile Image
    tanjingren
    Asked on November 03, 2017 at 01:39 AM

     Inconsistent date formats when responses exported as CSV.  - some as numbers (ideal), others as text, in a variety of formats. quite annoying to have to regularly regularize the formats.

  • Profile Image
    ashwin_d
    Answered on November 03, 2017 at 04:18 AM

    I'm sorry for the trouble caused to you. 

    I downloaded your last edited form's submission CSV file and I see the date format of "Preferred collection date" field in different format. Please check the screenshot below:

    1509696587csvDateFormat.gif


    Is this the issue you are having? I am reporting it to our backend team. We will get back to you as soon as we have any update from them.

  • Profile Image
    tanjingren
    Answered on November 03, 2017 at 04:50 AM

    Yes, that is a problem, but column A (submission date) is a problem too. Please help.


    Many thanks.

  • Profile Image
    ashwin_d
    Answered on November 03, 2017 at 04:55 AM

    Yes I did check the submission date field in submission CSV and it seems to display correctly. I have already reported this to our backend team. We will get back to you as soon as we have any update from them.