Date/Time Fields
In the Properties window for a date/time field, you specify the format in which to display values in the report. The following table describes the many choices available for Format under Format. The examples shown in this table are the same ones shown in the Properties window in the software.
Format
Example
Description
General Date
6/21/2008 12:40:23 PM
Displays a combination of the settings for Short Date and Long Time.
Long Date
Monday, June 21, 2008
Displays the Long Date setting specified in the Regional Settings Properties window in the Windows Control window.
Long Time
12:40:23 PM
Displays the time as set on the Time tab in the Regional Settings Properties window in the Windows Control window.
Medium Date
21-Jun-08
Displays the date, month (three-character abbreviation), and year (two-digit) with dashes between these elements.
Medium Time
12:40 PM
Displays the hour and minutes followed by an AM or PM indicator.
Month, Year
June, 2008
Displays the month and year, separated by a comma.
Quarter, Year
Quarter 2, 2008
Displays the calendar quarter and year, separated by a comma.
Short Date
6/21/2008
Displays the Short Date setting specified in the Regional Settings Properties window in the Windows Control window.
Short Time
12:40
Displays the hour and minutes in a 24-hour clock format.
Week
Week of 6/15/2008
Displays the date for the Sunday on the week in which the current date falls.
Year
2008
Displays the year.