Date Format
Date Format
You can use the data fields Datetime 1 and Datetime 2 and set those datas up inside Date Format 1 and Date Format 2 respectively. This gives you a very flexible solution to display date formats in whatever format you want.
Note
To give you as much options as possible I do offer custom date formats based on templates. Below you find the explanations on how to use them.
Pattern Syntax
All placeholders do use upper case letters only for simplicity and for being more intuitive. Be aware that the patterns are case sensitive, this means only uppercase letters do match the pattern and lowercase matches will not be interpreted as pattern but as plain text instead.
Placeholder | Meaning | Examples |
---|---|---|
%YYYY / %YY | Y… Year |
|
%MMM / %MM / %M | M… Month |
|
%DD / %D | D… Day in month |
|
%W | W… Weekday / Day in week |
|
%CC / %C | C… Calendar Week |
|
Examples
Following shows a list of some common used formats. You can use plain text inside your format as well if you want.
Example date: 05.10.2020
Pattern | Result |
---|---|
%YYYY-%MM-%DD | 2020-10-05 |
%YYYY/%MM/%DD | 2020/10/05 |
%DD.%MM.%YYYY | 05.10.2020 |
%W, %MM-%DD | Mon, 10-05 |
%MMM %DD, %YYYY | Oct 05, 2020 |
%W, %DD %MMM %YYYY | Mon, 05 Oct 2020 |
%W %DD, CW %CC | Mon 05, CW 41 |
%W %DD (Week %CC) | Mon 05 (Week 41) |
All english letters and nearly all punctations are supported.