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 FieldTime/Date FieldStep 2:Click on the Compute tab at the bottom of the screen. 

Compute TabStep 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
 Author: karperc Last Updated: 9/4/2014 1:11 PM   Page Views: 5446
<< Part the Date - InfoMaker Remove Time - InfoMaker  Java >>
https://helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=remove_time