Date Format

2024-05-31 2 min read
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.

PlaceholderMeaningExamples
%YYYY / %YYY… Year
  • %YYYY… 2020
  • %YY… 20
%MMM / %MM / %MM… Month
  • %MMM… Jan
  • %MM… 01
  • %M… 1
%DD / %DD… Day in month
  • %DD… 01
  • %D… 1
%WW… Weekday / Day in week
  • %W… Mon
%CC / %CC… Calendar Week
  • %CC… 05
  • %C… 5

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

PatternResult
%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.