The info_date_style() function
Get a table of info on the different date-formatting styles (which are used by supplying a number code to the fmt_date() function).
| Date Formatting Options |
Usable in the fmt_date() and fmt_datetime() functions |
|
Format Name |
|
Formatted Date |
| 1 |
iso |
|
2000-02-29 |
| 2 |
wday_month_day_year |
|
Tuesday, February 29, 2000 |
| 3 |
wd_m_day_year |
|
Tue, Feb 29, 2000 |
| 4 |
wday_day_month_year |
|
Tuesday 29 February 2000 |
| 5 |
month_day_year |
|
February 29, 2000 |
| 6 |
m_day_year |
|
Feb 29, 2000 |
| 7 |
day_m_year |
|
29 Feb 2000 |
| 8 |
day_month_year |
|
29 February 2000 |
| 9 |
day_month |
|
29 February |
| 10 |
day_m |
|
29 Feb |
| 11 |
year |
|
2000 |
| 12 |
month |
|
February |
| 13 |
day |
|
29 |
| 14 |
year.mn.day |
|
2000/02/29 |
| 15 |
y.mn.day |
|
00/02/29 |
| 16 |
year_week |
|
2000-W09 |
| 17 |
year_quarter |
|
2000-Q1 |
| 18 |
yMd |
FLEXIBLE |
2/29/2000 |
| 19 |
yMEd |
FLEXIBLE |
Tue, 2/29/2000 |
| 20 |
yMMM |
FLEXIBLE |
Feb 2000 |
| 21 |
yMMMM |
FLEXIBLE |
February 2000 |
| 22 |
yMMMd |
FLEXIBLE |
Feb 29, 2000 |
| 23 |
yMMMEd |
FLEXIBLE |
Tue, Feb 29, 2000 |
| 24 |
GyMd |
FLEXIBLE |
2/29/2000 A |
| 25 |
GyMMMd |
FLEXIBLE |
Feb 29, 2000 AD |
| 26 |
GyMMMEd |
FLEXIBLE |
Tue, Feb 29, 2000 AD |
| 27 |
yM |
FLEXIBLE |
2/2000 |
| 28 |
Md |
FLEXIBLE |
2/29 |
| 29 |
MEd |
FLEXIBLE |
Tue, 2/29 |
| 30 |
MMMd |
FLEXIBLE |
Feb 29 |
| 31 |
MMMEd |
FLEXIBLE |
Tue, Feb 29 |
| 32 |
MMMMd |
FLEXIBLE |
February 29 |
| 33 |
GyMMM |
FLEXIBLE |
Feb 2000 AD |
| 34 |
yQQQ |
FLEXIBLE |
Q1 2000 |
| 35 |
yQQQQ |
FLEXIBLE |
1st quarter 2000 |
| 36 |
Gy |
FLEXIBLE |
2000 AD |
| 37 |
y |
FLEXIBLE |
2000 |
| 38 |
M |
FLEXIBLE |
2 |
| 39 |
MMM |
FLEXIBLE |
Feb |
| 40 |
d |
FLEXIBLE |
29 |
| 41 |
Ed |
FLEXIBLE |
29 Tue |