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" ??
Comments
0 comments