Config / Advanced Topics / Working with Date/Time Format Strings

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:

CCYY

The year with century information, e.g. 2019. (4 characters)

YY

The year, e.g. 19. (2 characters)

MM

The month, e.g. 01. (2 characters)

DD

The day, e.g. 31. (2 characters)

WW

The calendar week, e.g. 19. (2 characters)

The following time components are supported on imports:

HH

The hour represented as 2 digits in the range of 0-23.

mm

The minutes. (2 characters)

ss

The seconds. (2 characters)

Export

To format date and time values on exports there are a few more options available than on imports:

CCYY

The year with century information, e.g. 2019. (4 characters)

YY

The year, e.g. 19. (2 characters)

MM

The month, e.g. 01. (2 characters)

M

The month, e.g. 1. (1-2 characters)

DD

The day, e.g. 31. (2 characters)

D

The day, e.g. 7. (1-2 characters)

WW

The calendar week, e.g. 19. (2 characters)

W

The calendar week, e.g. 9. (1-2 characters)

QQ

The quarter, e.g. 01. (2 characters)

Q

The quarter, e.g. 1. (1 characters)

The following time components are supported on exports:

HH

The hour represented as 2 digits in the range of 0-23.

H

The hour represented as 1-2 digits in the range of 0-23.

mm

The minutes. (2 characters)

m

The minutes. (1-2 characters)

ss

The seconds. (2 characters)

s

The seconds. (1-2 characters)