##Common Date Patterns##
Panorama date patterns supports a wide variety of date formats. The table below lists several common date patterns. Date patterns must be surrounded by quotes.
Date |
Pattern |
Display |
---|---|---|
3/9/2002 |
mm/dd/yy |
3/9/02 |
3/9/2002 |
MM/DD/YY |
03/09/02 |
3/9/2002 |
mm-dd-yyyy |
3-9-2002 |
3/9/2002 |
dd-MON-yy |
9-MAR-02 |
3/9/2002 |
dd-Month-yy |
9-March-02 |
3/9/2002 |
Month dd, yyyy |
March 9, 2002 |
3/9/2002 |
Month ddnth, yyyy |
March 9th, 2002 |
3/9/2002 |
DayOfWeek, Month ddnth, yyyy |
Saturday, March 9th, 2002 |
3/9/2002 |
qq"q"yy |
1q02 |
3/9/2002 |
"Week" ww "of" yyyy |
Week 11 of 2002 |
3/9/2002 |
YYYYMMDD |
20020309 |
5/23/2002 |
Quarter "Quarter" yyyy |
Second Quarter 2002 |
7/11/2004 |
Qtr "Qtr" yyyy |
3rd Qtr 2004 |
3/9/2002 |
"Day" dd, "Month" mm |
Day 9, Month 3 |
3/1/2002 |
ddnth "day of" Month, yyyy |
1st day of March, 2002 |
3/2/2002 |
ddnth "day of" Month, yyyy |
2nd day of March, 2002 |
3/9/2002 |
ddnth "day of" Month, yyyy |
9th day of March, 2002 |
3/1/1867 |
mmnth "month of" yyyy |
3rd month of 1867 |
##Components##
There are 21 different basic components that can be used as part of a date pattern. A date pattern is built up by combining these components together with punctuation to build a complete pattern. Unlike Panorama 6 and earlier versions, components must be separated by one or more characters. There are 6 components that combine month day and year into a single component.
Component |
Example |
Description |
---|---|---|
yy |
02 |
Year (within century) |
yyyy |
2002 |
Year (including century) |
qq |
2 |
Quarter (numeric) |
qtr |
2nd |
Quarter (abbreviated) |
quarter |
second |
Quarter (spelled out) |
mm |
9 |
Month (numeric) |
MM |
09 |
Month (with leading zero) |
mon |
sep |
Month (abbreviated) |
month |
september |
Month (spelled out) |
ww |
46 |
Week (within year) |
dd |
5 |
Day (numeric) |
DD |
05 |
Day (with leading zero) |
day |
tue |
Day Of Week (abbreviated) |
dayofweek |
tuesday |
Day Of Week (spelled out) |
DDMMYY |
3 |
Day, Month, Year (with no separators) |
MMDDYY |
3 |
Month, Day, Year (with no separators) |
YYMMDD |
3 |
Year, Month, Day (with no separators) |
DDMMYYYY |
3 |
Day, Month, Century, Year (with no separators) |
MMDDYYYY |
3 |
Month, Day, Century, Year (with no separators) |
YYYYMMDD |
3 |
Century, Year, Month, Day (with no separators) |
##Upper/Lower Case##
Some of these components (qtr, quarter, mon, month, day, and dayofweek) can be either upper or lower case. The table below shows how a component can be displayed in all lower case, initial caps, or all upper case.
Pattern |
Display |
---|---|
month |
september |
Month |
September |
MONTH |
SEPTEMBER |
dayofweek |
friday |
DayOfWeek |
Friday |
DAYOFWEEK |
FRIDAY |
##Quoted Literals##
If you need to include the words qtr, quarter, mon, month, or day in your date, you must quote them so that they are not treated as components. Be sure to use regular straight quotes, not smart (curly) quotes. Since the text itself contains quotes, you will need to surround the pattern with a different quote character. In the following examples we have used {} as the quote characters surrounding each pattern.
Pattern |
Converted Text |
---|---|
{Quarter "Quarter" YYYY} |
First Quarter 1992 |
{"Day" dd, "Month" mm} |
Day 9, Month 3 |
You can add the suffix nth to the mm, ww, or dd components, as shown below.
Date |
Pattern |
Converted Text |
---|---|---|
3/1/89 |
{ddnth "day of" Month} |
1st day of March |
3/2/89 |
{ddnth "day of" Month} |
2nd day of March |
3/9/89 |
{ddnth "day of" Month} |
9th day of March |
3/9/89 |
{Month ddnth, yyyy} |
March 9th, 1989 |
3/9/89 |
{mmnth "month of" yyyy} |
3rd month of 1989 |
Panorama automatically adds the correct suffix.
See Also