Standard Date Formats
You can specify the appearance of the dates in the date scale by entering a format for the date.
These date formats are used in date scaling, calculated fields, and global edits. The following table lists the date scale parameters.
| Parameter | Definition | Example |
|---|---|---|
| %T | Minute | 15 |
| %H | Hour | 08 |
| %Z | AM or PM | AM or PM |
| %OZ | AM or PM (lower case) | am or pm |
| %D | Day of the month | 31 |
| %V | Day | Tuesday |
| %OV | Day (lower case) | tuesday |
| %UV | Day (upper case) | TUESDAY |
| %W | Day abbreviation | Tues |
| %OW | Day abbreviation (lower case) | tues |
| %UW | Day abbreviation (upper case) | TUES |
| %F | First letter of name of day of the week | T |
| %OF | First letter of the name of day of the week (lower case) | t |
| %UF | First letter of the name of day of the week (upper case) | T |
| %K | Numeric week | 22 |
| %M | Numeric month | 10 |
| %L | Month | October |
| %OL | Month (lower case) | october |
| %UL | Month (upper case) | OCTOBER |
| %A | Month abbreviation | Oct |
| %OA | Month abbreviation (lower case) | oct |
| %UA | Month abbreviation (upper case) | OCT |
| %S | First letter of name of month | O |
| %OS | First letter of name of month (lower case) | o |
| %US | First letter of name of month (upper case) | O |
| %Q | Numeric quarter | 4 |
| %C | Year | 2004 |
| %Y | Two-digit year | 04 |
You can combine parameters to define date formats, provided that you do not include two parameters that represent the same time unit. You can also include spaces and literal characters in the format text box, as shown in the following examples.
| Format | Example |
|---|---|
| %H:%T %Z. | 07:15 PM |
| %W %D %A %H:%T | Mon 13 Sep 19:15 |
| %M/%D/%Y | 09/13/04 |
| Q%Q | Q1 |
| %R%H Hours | 100 Hours |
| Day %R%D | Day 3 |