Date Formats Dialog Box
The Date Formats dialog box displays a list of date formats that Open Plan can use.
If the date format you choose is a character string, you can also choose from the following capitalization options:
- Upper Case: For example, "TUESDAY"
- Mixed Case: For example, "Tuesday"
- Lower Case: For example, "tuesday"
For most numeric date formats, an option is enabled that allows you to use relative dates. If selected, this option inserts %R into the format.
Open Plan inserts your format selection into the Format field in the Date Scale dialog box.
Date Format Examples
You can specify the appearance of the dates in the date scale by entering a format for the date. The following table lists the parameters that can be included.
| 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 |
| %R%H | Relative hours | 100 |
| %R%D | Relative days | 3 |
| %R%K | Relative weeks | 22 |
| %R%M | Relative months | 4 |
| %R%Q | Relative quarters | 2 |
| %R%Y | Relative years | 1 |
Because the %R parameters return only a numeric value, combine them with literal characters to make them more informative.
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 15 Sep 19:15 |
| %M/%D/%C | 09/15/04 |
| Q%Q | Q1 |
| %R%H Hours | 100 Hours |
| Day %R%D | Day 3 |