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) will cause 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 will need to use the Text to Number Modifier.
Table: Date/Time Modifier Formats
Format | Example |
---|---|
Short Date | 12/4/2016 |
Short Time | 6:14 PM |
Long Date | Thursday, December 04, 2016 |
Short Date & Time | 12/4/2016 6:14 PM |
Long Date & Time | Thursday, December 04, 2016 6:14 PM |
Sortable Date & Time | 2016-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) | 16 |
Year (long) | 2016 |
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 16-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
|