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.
Examples
Führen zu folgendem Ergebnis: |
---|
|
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
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.
For more information on formatting please refer to
Grundbegriffe Formate