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. Step 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)"
Author: karperc | Last Updated: 9/4/2014 1:08 PM | Page Views: 5031 |
https://helpdesk.etown.edu/helpconsole2012/KB/default.aspx?pageid=part_the_date
|