Chapter 7 Date and Time Functions The following functions can be used to get and set date and time data. Function Usage Description CALCDATE Add days, weeks, months and years to a date CALCTIME Add hours and minutes to a time DATE Construct date from day, month and year DAYNUM Return day number of a date DAYSTR Return day name of a date HOURNUM Return hours part of a time MINSNUM Return minutes part of a time MONTHNUM Return month number of a date MONTHSTR Return month name of a date TIME Construct time from hour and minute WEEKNUM Return week number of a date YEARNUM Return years part of a date
