Format Dates
These steps explain how to make your Query results easier to read by formatting the dates.
-
The terms file, field, and record may also be referred to as table, column, and row in the context of Queries. For details, refer to the online course CMS 100 - Report Builder: Canned Query.
-
Launch Tool #100 CU*BASE Report Builder (Query).
-
Select the desired options on the Build a Report screen.
-
Click the forward arrow.
-
Select the desired files, fields, records, and sorting options on the Report Builder - Main Menu screen.
-
Click Format Columns.
-
On the Specify Report Column Formatting screen, click the edit button (pencil icon) button corresponding to the field whose date formatting you'd like to change.
-
Ensure that the Edit option is set to Date or Time Editing on the Define Numeric Field Editing screen.
-
Click the forward arrow.
-
Select the desired option from the Date/time separator drop-down menu on the Describe Date/Time Field Editing screen.
-
Click the forward arrow.