The date format can be defined by:
The following table displays some example Custom Format options for Date and Time Columns.
| Custom Format |
Result |
|
MM/dd/yyyy |
05/15/2008 |
|
YYYY-MM-DDTHH:MM:SSZ |
2008-04-17T12:00:00Z |
|
dddd, dd MMMM yyyy |
Thursday, 15 May 2008 |
|
dddd, dd MMMM yyyy HH:mm |
Thursday, 15 May 2008 09:35 |
|
dddd, dd MMMM yyyy hh:mm tt |
Thursday, 15 May 2008 09:35 AM |
|
dddd, dd MMMM yyyy H:mm |
Thursday, 15 May 2008 9:35 |
|
dddd, dd MMMM yyyy h:mm tt |
Thursday, 15 May 2008 9:35 AM |
|
dddd, dd MMMM yyyy HH:mm:ss |
Thursday, 15 May 2008 09:35:17 |
|
MM/dd/yyyy HH:mm |
05/15/2008 09:35 |
|
MM/dd/yyyy hh:mm tt |
05/15/2008 09:35 AM |
|
MM/dd/yyyy H:mm |
05/15/2008 9:35 |
|
MM/dd/yyyy h:mm tt |
05/15/2008 9:35 AM |
|
MM/dd/yyyy HH:mm:ss |
05/15/2008 09:35:17 |
|
MMMM dd |
May 15 |
|
yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK |
2008-05-15T09:35:17.2878075-04:00 |
|
ddd, dd MMM yyyy HH':'mm':'ss 'GMT' |
Thu, 15 May 2008 09:35:17 GMT |
|
yyyy'-'MM'-'dd'T'HH':'mm':'ss |
2008-05-15T09:35:17 |
|
HH:mm |
09:35 |
|
hh:mm tt |
09:35 AM |
|
HH:mm:ss |
09:35:17 |
|
yyyy'-'MM'-'dd HH':'mm':'ss' |
2008-05-15 09:35:17 |
|
yyyy MMMM |
2008 May |