Export CSV with recognisable date formats

Hi there,

When exporting any CSV data from BG, the format of the dates includes a plus sign and "00" within the field. I understand that this extra text is a timezone offset. Unfortunately, this format is not recognised as a date by Excel or any other data analysis tool without first trimming the extra text or setting up a special import map. Is it possible to export the DateTime fields as simple Excel-friendly "dd/mm/yyyy hh:mm" ??

Didn't find what you were looking for?

New post
Would you like to vote for this feature?
2 out of 2 found this helpful

Comments

0 comments