Removing Time of Day Details from a Calendar Time

If you have a Calendar Time and you would just like to remove the time of day (TOD) then you can use the routine editor to perform this.

For example if you have real time of 23 Jan 2009 11:17 , and would like to just have the calendar date only as the value:

Set a routine editor to the real time: set r.realtime = 23 Jan 2009 11:17

Use the operation Day of month in category Time to get the day. eg r.Day = DayofMonth(r.realtime)

Use the operation Month of Year in category Time to get the month. eg r.Month = MonthofYear(r.realtime)

Use the operation Year of Date in category Time to get the year. eg r.Year = YearofDate(r.realtime)

Then, use the Form Date function in category Time for form the date. eg r.Calendar Date = (r.Day, r.Month, r.Year).

Therefore r.Calendar Date will equal 23 Jan 2009.