You can create custom formats for dates and times. The following date/time designations are available:
|
Date/Time Code |
Description |
Example |
|
m/d/yy |
Month single digit number excludes leading 0, 1-12, then Day single digit numbers excludes leading 0, 1-31, then Last two digits of year |
7/14/09 |
|
mm/dd/yy |
Month double digit number includes leading 0, 01-12, then Day double digit numbers including leading 0, 01-31, then Last two digits of year |
07/14/09 |
|
mmm dd, yyyy |
Month name abbreviated, then the Day double digit numbers including leading 0, 01-31, then Year |
Jul 14, 2009 |
|
mmmm dd, yyyy |
Month name, then the Day double digit numbers including leading 0, 01-31, then Year |
July 14, 2009 |
|
d-mmm-yy |
Day single digit numbers excludes leading 0, 1-31, then Month name abbreviated, then Last two digits of year |
14-Jul-09 |
|
d-mmm |
Day single digit numbers excludes leading 0, 1-31, then Month name abbreviated |
14-Jul |
|
mmm-yy |
Month name abbreviated, then Last two digits of year |
Jul-09 |
|
mmm-yyyy |
Month name abbreviated, then Year |
Jul-2009 |
|
mmmm-yyyy |
Month name, then Year |
July-2009 |
|
h:nn AM/PM |
Hour in standard format, then Minutes, 0 to 60, then a space and AM or PM |
2:45 PM |
|
h:nn:ss AM/PM |
Hour in standard format, then Minutes, 0 to 60, then Seconds, 0 to 60, then a space and AM or PM |
2:45:44 PM |
|
hh:nn |
Hour, 0-23 (military time), then Minutes, 0 to 60 |
14:45 |
|
hh:nn:ss |
Hour, 0-23 (military time), then Minutes, 0 to 60, then Seconds, 0 to 60 |
14:45:44 |
|
m/d/yy hh:nn |
Month single digit number excludes leading 0, 1-12, then Day single digit numbers excludes leading 0, 1-31, then Last two digits of year, then a space and Hour, 0-23 (military time), then Minutes, 0 to 60 |
7/04/09 14:45 |
|
yyyy |
Year |
2009 |
|
yy |
Last two digits of year |
09 |
|
mmmm |
Month name |
April |
|
mmm |
Month name abbreviated |
Apr |
|
mm |
Month double digit number includes leading 0, 01-12 |
04 |
|
m |
Month single digit number excludes leading 0, 1-12 |
4 |
|
dddd |
Day name |
Tuesday |
|
ddd |
Day name abbreviated |
Tue |
|
dd |
Day double digit numbers including leading 0, 01-31 |
14 |
|
d |
Day single digit numbers excludes leading 0, 1-31 |
14 |
|
d/m/yy |
Day single digit numbers excludes leading 0, 1-31, then Month single digit number excludes leading 0, 1-12, then Last two digits of year |
14/7/09 |
|
dd/mm/yy |
Day double digit numbers including leading 0, 01-31, then Month double digit number includes leading 0, 01-12, then Last two digits of year |
14/07/09 |
|
yy/mm/dd |
Last two digits of year, then Month double digit number includes leading 0, 01-12, then Day double digit numbers including leading 0, 01-31 |
09/07/14 |
|
yyyy-mm-dd |
Year, then Month double digit number includes leading 0, 01-12, then Day double digit numbers including leading 0, 01-31 |
2009-07-14 |
To add new date/time designations, use any combination of the following codes:
|
yyyy |
Year |
2009 |
|
yy |
Last two digits of year |
09 |
|
mmmm |
Month name |
April |
|
mmm |
Month name abbreviated |
Apr |
|
mm |
Month double digit number includes leading 0, 01-12 |
04 |
|
m |
Month single digit number excludes leading 0, 1-12 |
4 |
|
dddd |
Day name |
Tuesday |
|
ddd |
Day name abbreviated |
Tue |
|
dd |
Day double digit numbers including leading 0, 01-31 |
14 |
|
d |
Day single digit numbers excludes leading 0, 1-31 |
14 |
|
hh |
Hour, 0-23 (military time) |
18 |
|
h |
Hour in standard format |
6 |
|
nn |
Minutes, 0 to 60 |
45 |
|
ss |
Seconds, 0 to 60 |
44 |
|
tt |
AM or PM |
AM |
|
mm/dd/yy h:nn:ss tt |
Month double digits, Day double digits, Year double digits, Hour in standard format, Minutes, Seconds and AM/PM designation |
04/14/09 6:45:44 PM |
See Also