The formula field allows you to create custom date formats. The following table describes the formula date commands. For these examples the date is 11/18/2009 and the time is 15:41:15.
|
Code |
Definition |
Result |
|---|---|---|
|
0 |
MM,YY |
11,09 |
|
1 |
MM,YYYY |
11,2009 |
|
2 |
MM-YY |
11-09 |
|
3 |
MM-YYYY |
11-2009 |
|
4 |
MM/YY |
11/09 |
|
5 |
MM/YYYY |
11/2009 |
|
6 |
MM/DD/YY |
11/18/09 |
|
7 |
MM-DD-YY |
11-18-09 |
|
8 |
MM/DD/YYYY |
11/18/2009 |
|
9 |
MM-DD-YYYY |
11-18-2009 |
|
10 |
DD/MM/YY |
18/11/09 |
|
11 |
DD-MM-YY |
18-11-09 |
|
12 |
DD/MM/YY |
18/11/09 |
|
13 |
DD-MM-YYYY |
18-11-2009 |
|
14 |
YY/MM/DD |
09/11/18 |
|
15 |
YY-MM-DD |
09-11-18 |
|
16 |
YYYY/MM/DD |
2009/11/18 |
|
17 |
YYYY-MM-DD |
2009-11-18 |
|
18 |
DD-MMM-YY |
18-Nov-09 |
|
19 |
DD-MMM-YYYY |
18-Nov-2009 |
|
20 |
DD-MMM |
18-Nov |
|
21 |
MMMDD,YY |
Nov 18, 09 |
|
22 |
MMMDD,YYYY |
Nov 18, 2009 |
|
23 |
MMM-YY |
Nov-09 |
|
24 |
MMM-YYYY |
Nov-2009 |
|
25 |
HHMMPM |
3:41PM |
|
26 |
HHMMP |
3:41P |
|
27 |
HHMMSSPM |
3:41:15PM |
|
28 |
HHMM |
15:41 |
|
29 |
HHMMSS |
15:41:15 |
|
30 |
MM/DD/YY HHMM |
11/18/09 15:41 |
|
31 |
MM/DD/YY HHMMPM |
11/18/09 3:41PM |
|
32 |
MM/DD/YY HHMMP |
11/18/09 3:41P |
|
33 |
MM/DD/YYYY HHMM |
11/18/2009 15:41 |
|
34 |
MM/DD/YYYY HHMMPM |
11/18/2009 3:41PM |
|
35 |
MM/DD/YYYY HHMMP |
11/18/2009 3:41P |
|
36 |
MMMDD,YY HHMM, |
Nov 18, 09 15:41 |
|
37 |
MMMDD,YY HHMMPM |
Nov 18, 09 3:41PM |
|
38 |
MMMDD,YY HHMMP |
Nov 18, 09 3:41P |
|
39 |
MMMDD,YYYY HHMM |
Nov 18, 2009 15:41 |
|
40 |
MMMDD,YYYY HHMMPM |
Nov 18, 2009 3:41PM |
|
41 |
MMMDD,YYYY HHMMP |
Nov 18, 2004 3:41P |