Choose Number and Date format in Export profiles

Owned by Thomas Speekenbrink
Last updated: Sept 04, 2019 by Jan Verlaan (Unlicensed)
1 min read

Overview

When exporting your data from SuperOffice to a Text file (csv) or XML report it is possible to choose the Number and Date format. 

Note

When we export to Excel we convert the date and number to the Excel format date and number.
They are not strings like in txt or csv but numbers. 
e.g. the date 14-12-2018 13:00:00 in Excel is 43448,5416666667

With the function "cell properties" Excel can display any date format the user wants.

Resulting in the fact that there is no possibility to transform the date before creating the Excel sheet. You have to manage this in the Excel sheet itself, via the cell properties, before it is handed over to other systems to import.

How to

Create a new export profile or select and manage an existing Export Profile

In the Destination Settings, you can now choose the Number format and the Date format