Custom date format
After choosing Custom from the date format drop-down list, click browse. The Date Format dialog box is displayed.
You can only use non-alphanumeric characters (excluding the {, } and [, ] non-alphanumeric characters) as separators in the custom Date Format dialog box.
The following table provides examples of date formats.
Date Format | Description | Example |
---|---|---|
CCYY | 4-digit Century + Year | 1999 |
YY | 2-digit Year (00-99) | 99 |
MM | 2-digit Month (01-12) | 12 |
M | 1- or 2-digit Month (1-12) | 8 |
MON | 3-character Month (Jan to Dec) | JAN |
MONTH | Full name of Month | January |
DDD | 3-digit Day of year (001-366) | 32 |
DD | 2-digit Day of Month (01-31) | 31 |
D | 1- or 2-digit Day of Month (1-31) | 7 |
DY | 3-character Day of Week (Sun-Sat) | Fri |
DAY | Full Name of Day of Week (Sunday-Saturday) | Friday |
WW | 1- or 2-digit Week of Year | 13 |
Qn | Quarter of Year (Q1-Q4) | Q2 |
Custom | User defined custom date format |
After you define and save a custom format, the custom format string is displayed in the Properties window. For example, the custom date format CCYYMMDD, and the custom time format HH24MMSS display as:
{CCYYMMDD}{HH24MMSS}