BookmarkPrint
Contents
Home > Software & Programs > InfoMaker > Part the Date - InfoMaker


Part the Date - InfoMaker
You can divide the date into separate columns in InfoMaker. Instead of displaying the month, day, and year in the same field, you can separate them into different columns. This example separates the parts of a birth date into month, day and year columns.

Step 1:Open the query in InfoMaker. Step 2:
Select the Compute tab at the bottom of the screen. Compute TabStep 3:
Enter the following to separate the date into three fields:
"birth_mth = datepart(mm,biograph_master.birth_dte)"
"birth_day = datepart(dd,biograph_master.birth_dte)"
"birth_year = datepart(yyyy,biograph_master.birth_dte)"
Part Date Fields
Related Articles


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