BookmarkPrint
Contents
Home > Software & Programs > InfoMaker > Remove Time - InfoMaker


Remove Time - InfoMaker
You can remove the time from a date/time field in InfoMaker. The time displays as 00:00:00, which is not necessary to show. 
Step 1:Open the query in InfoMaker. 

Time/Date Field
Time/Date FieldStep 2:Click on the Compute tab at the bottom of the screen. 

Compute Tab
Step 3:In the text box, type the following:
"grad_date = cast(DEGREE_HISTORY.DEG_APPLICATION_DTE as DATE)". 
Note: "grad_date" is the new column title. Enter the name for your new column, using _ for spaces. 
"DEGREE_HISTORY" is the table. Adjust this according to the name of your table. "DEG_APPLICATION_DTE" is the name for the date/time field. 


grad_date = cast(DEGREE_HISTORY>DEG_APPLICATION_DTE as DATE)
Step 4:The query will now display only the date. 

Date Field

Date Field

Related Articles


helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=remove_time