Modify the Date and Time Format for a Column

The Layout tab in the Options dialog box for a report displays the default date and time format for the report. That format is the default format for each date field on the report. On the Columns tab of the Options dialog box, you can modify the format for individual columns.

To modify the date and time format for a column, complete the following steps:

1. Click the Columns tab on the Options dialog box.
2. Click the Format grid column for the report column and click to open the Format Date/Time dialog box.
3. In Type, indicate if you want the default to be the short, medium, or long date, the date and time combination, or the time.
4. If you selected Short date or Short date and time in Type and you want to use the date separator from your Regional and Language Options in Windows, select Use separator from regional settings.
5. If you want to use a different separator, clear that check box and select a separator from the drop-down list in Date Separator; if you want to use a separator that is not in the drop-down list, type the separator character in the field. For date formats other than the short date format, Vision uses the punctuation specified in your Regional and Language Options for Windows.
6. In Date order, select the order in which you want Vision to display the day, month, and year components of the date.
7. If you do not want dates to include the day, month, or year, clear the Display day, Display month, and/or Display year check boxes.
8. If you want dates to display all four digits of the year, select Display four digit year.
9. If you want dates to include leading zeros when the days or numerical months are less than 10, select Display leading zeros.
10. If the default date includes the time and you want to use the time separator from your Regional and Language Options in Windows, select Use separator from regional settings in the Time Options group box. The time separator is the character that separates hours from minutes, and minutes from seconds. If you want to use a different separator, clear that check box and select a separator from the drop-down list in Time Separator. If you want to use a separator that is not in the drop-down list, enter the separator character in the field.
11. If you want times displayed based on a 24-hour clock rather than a 12-hour clock, select 24-hour clock (1:00 p.m. displays as 13:00).
12. If you want an a.m. or p.m. indicator displayed as part of the time, select Display AM/PM. Vision uses the a.m. and p.m. indicators specified in your Regional and Language Options for Windows.
13. Click OK to return to the Options dialog box. The Format grid column displays the modified format.
14. After you set all report options, click Apply.