Changes in format for the orders export spreadsheet Authorized Date field aims to ensure the quality of our data
Published on5/23/2019
•
Last updated on11/27/2020
1 min read
Starting June 12th, 2019, we will change the format of the Authorized Date field, found in the orders report which is exported from the Order Management module.
Key Advantages
The new Authorized Date field format ensures an easier and clearer understanding of the date when the order was authorized. In addition, it follows the default of the other already existing report dates, making editing data easier and more intuitive.
Necessary steps
If you are using a macro or automation that takes the Authorized Date field into consideration, you need to pay attention to the yyyy-MM-dd HH:mm:ss formatting field, where:
yyyyrepresents the four digits of the yearMMare the two digits of the monthddare the two digits of the dayHHrepresents the hour, in 24-hour formatmmare the two digits for minutesssare the two digits for seconds