General Calendar
Summary
Adds a column to the table that contains calendar information such as weekday, month, year, day of the week, week of year in predefined or user-defined formats or (see date and time formats in Formatting strings).
The operator requires at least one column of the data type Date/Time.
Example
Want to learn more?
Settings
-
Columns of input table
Parameter
Examples
Example 1: Only one date column
Ausgangssituation |
|---|
|
Folgende Einstellungen: |
|---|
|
Führen zu folgendem Ergebnis: |
|---|
|
Example 2: Weekday
The following settings … |
|---|
Entering: Name of the identifier column: Weekday ... free format: ddd |
…yield the following result |
|---|
Column with weekdays as short text Weekday MON TUE |
Note |
|---|
HH:mm results in 24h display HH:00 results in full hours MMM results in months JAN, FEB, MAR … Formatting is explained in Help and is similar to the options in EXCEL. |
Troubleshooting
Support & Troubleshooting
Free format
- The symbol for day is d.
- The symbol for month is M.
- The symbol for minute is m.
- The symbol for two-digit year is yy.
Related topics
- ...