Date/Time Modifier Formats
Date/time modifier formats take the date/time values and converts them to text in a number of different ways. The table below shows all of the supported formats, along with an example. The example date/time is 12/4/2016 6:14 PM. Using an @ symbol in the format (example: 12/4/2016 @ 6:14 PM) causes incorrect modifier outcomes.
After applying a date/time format, the resulting value is considered to be text. Users can then apply any text operators to the value. For example, if you want to use the result as a number (example: Day), then you need to use the Text to Number modifier.
The formats may change depending on system settings. For
example, the
Short Date format is based on the regional
settings of the current user’s machine.
Table: Date/Time Modifier Formats
| Format | Example |
|---|---|
| Short Date | 12/4/2021 |
| Short Time | 6:14 PM |
| Long Date | Thursday, December 04, 2021 |
| Short Date & Time | 12/4/2021 6:14 PM |
| Long Date & Time | Thursday, December 04, 2021 6:14 PM |
| Sortable Date & Time | 2021-12-04T18:14:13 |
| Day | 4 |
| Day (with leading 0) | 04 |
| Day of Week (short) | Thu |
| Day of Week (long) | Thursday |
| Month (number) | 12 |
| Month (name) | December |
| Year (short) | 21 |
| Year (long) | 2021 |
| Hour (12-hour) | 6 |
| Hour (12-hour with leading 0) | 06 |
| Hour (24-hour) | 18 |
| Minute | 14 |
| Minute (with leading 0) | 014 |
| AM/PM | PM |
| Z | Client time zone
For use with the CreatedDateTime token. MM/dd/yyyy
hh:mm:ss tt Z
|
| Custom | Custom requires knowledge of the legal .NET
date/time formats. An example, however would be something like: yy-M-d ddd
which would return 21-12-4 Thu. See
this resource for more information on
custom formatting.
There is a
Cherwell-specific
custom modifier for a client's local time zone. Use a capital Z (capitalization
is important) with any date/time field
|