Blank fields being replaced with export date time stamp in CSV download

There is a bug that caused blank date fields in CSV reports to be replaced with the current date/time. This happens only when the report is exported from the Web dashboard.
As part of the fix we took a two-step approach:

  • The blank date fields are returned as empty fields instead of current date/time.
  • We also changed the CSV download feature so that the exported CSV has date fields that can be filtered/sorted inside Excel. So instead of returning date/time fields as “30th May at 2:55pm” – which is not a date/time in Excel – the CSV will now be formatted “dd-mmm-yy hh:mm:ss”, which in Excel will automatically render to the standard date/time format used in your region.
No Comments

Post a Comment

Related Posts