With field configurations, you can choose to set up a custom date format to display the date value in a field that is a string or date type. The Custom Format option on the context menu of the Field Configuration or Edit Shared Fields dialog box allows you to define a format for the date that is composed of several characters. There are also single characters that provide preformatted date and time information.
Single-character formats
The table below shows single characters that can be used to provide date formats when field configurations are used.
| Character | Description | Example |
|---|---|---|
d | Displays the date as month/day/year. | 7/19/2011 |
D | Displays the long version of the date including the day of the week. | Thursday, July 21, 2011 |
f | Displays the long version of the date, including the day of the week, and the time. | Thursday, July 21, 2011 8:30 AM |
F | Displays the long version of the date and the time with seconds. | Thursday, July 21, 2011 8:30:36 AM |
g | Displays the date as month/day/year and the time as hours:minutes with the AM or PM designator. | 7/21/2011 8:30 AM |
G | Displays the date as month/day/year and the time as hours:minutes:seconds with the AM or PM designator. | 7/21/2011 8:30:36 AM |
m or M | Displays the month and day without the year. | July 19 |
r or R | Displays the long version of the date as day of the week, day, month, year with the day and month abbreviated and the time in 24-hour GMT format. | Thu, 21 Jul 2011 08:30:36 GMT |
s | Displays the date as year-month-day and the time in 24-hour format. | 2011-07-21T08:30:36 |
t | Displays the time as hours:minutes with the AM or PM designator. | 8:30 AM |
T | Displays the time as hours:minutes:seconds with the AM or PM designator. | 8:30:36 AM |
u | Displays the date as year-month-day and time in hours:minutes:seconds format. | 2011-07-21 08:30:36Z |
U | Displays the date as day of the week, month, day, year and the time in hours:minutes:seconds with the AM or PM designator; the time displayed is universal and not the local time. | Thursday, July 21, 2011 3:30:36 PM |
y or Y | Displays the month and year. | July, 2011 |
Characters that can be used as parts of date and time formats
The table below contains characters that can be used in conjunction with each other to create a custom date and time format. Some of these characters are the same as the single-character formats but provide different information when combined with other parts of the date and time format.
| Character | Description | Example |
|---|---|---|
d | Displays the day without leading zeroes in a date string | x/9/xxxx |
dd | Displays the day with leading zeroes in a date string | x/09/xxxx |
ddd | Displays the three-letter abbreviation of the day of the week in a date string | Thu |
dddd | Displays the full name of the day of the week in the date string | Thursday |
g or gg | Displays the full name of the current era in a date string | x/x/xxxx A.D. |
h | Displays the hour without leading zeroes, ranging from 1 to 12, in a time string | 8:xx |
hh | Displays the hour with leading zeroes, ranging from 01 to 12, in a time string | 08:xx |
H | Displays the hour without leading zeroes, ranging from 1 to 23, in a time string | 8:xx |
HH | Displays the hour with leading zeroes, ranging from 01 to 23, in a time string | 08:xx or 20:xx |
m | Displays the minute without leading zeroes, ranging from 1 to 59, in a time string | x:9 |
mm | Displays the minute with leading zeroes, ranging from 01 to 59, in a time string | x:09 |
M | Displays the month number without leading zeroes, ranging from 1 to 12, in a date string | 7/xx/xxxx |
MM | Displays the month number with leading zeroes, ranging from 01 to 12, in a date string | 07/xx/xxxx |
MMM | Displays the abbreviation for the month name in a date string | Jul x, xxxx |
MMMM | Displays the full month name in a date string | July x, xxxx |
s | Displays the seconds without leading zeroes, ranging from 1 to 59, in a time string | x:xx:3 |
ss | Displays the seconds with leading zeroes, ranging from 01 to 59, in a time string | x:xx:03 |
t | Displays the first character in the AM or PM designator in a time string | x:xx A |
tt | Displays the AM or PM designator in a time string | x:xx AM |
y | Displays the year as two digits without leading zeroes, ranging from 0 to 99 in a date string | x/x/9 |
yy | Displays the year as two digits with leading zeroes, ranging from 00 to 99 in a date string | x/x/09 |
yyy or yyyy | Displays the full year, including the century, in a date string | x/x/2009 |
zz | Displays the offset for Greenwich mean time, in hours, with leading zeroes in a time string. | x:xx -07 |
zzz | Displays the offset for Greenwich mean time in hours and minutes in a time string | x:xx -07:00 |