Working with Date/Time Format Strings
You can specify the formatting of dates using the placeholders shown below. You can use any separation character you like, as long as it does not conflict with the supported variable names.
A typical example would be “CCYY-MM-DD” for an ISO formatted date, or “MM/DD/YY” for an date, like it is used in the United States.
Import
The following date components are supported:
The year with century information, e.g. 2019. (4 characters)
The year, e.g. 19. (2 characters)
The month, e.g. 01. (2 characters)
The day, e.g. 31. (2 characters)
The calendar week, e.g. 19. (2 characters)
The following time components are supported on imports:
The hour represented as 2 digits in the range of 0-23.
The minutes. (2 characters)
The seconds. (2 characters)
Export
To format date and time values on exports there are a few more options available than on imports:
The year with century information, e.g. 2019. (4 characters)
The year, e.g. 19. (2 characters)
The month, e.g. 01. (2 characters)
The month, e.g. 1. (1-2 characters)
The day, e.g. 31. (2 characters)
The day, e.g. 7. (1-2 characters)
The calendar week, e.g. 19. (2 characters)
The calendar week, e.g. 9. (1-2 characters)
The quarter, e.g. 01. (2 characters)
The quarter, e.g. 1. (1 characters)
The following time components are supported on exports:
The hour represented as 2 digits in the range of 0-23.
The hour represented as 1-2 digits in the range of 0-23.
The minutes. (2 characters)
The minutes. (1-2 characters)
The seconds. (2 characters)
The seconds. (1-2 characters)