Date and Time predefined functions
DateToNum ( date )
This function converts a date string to a number. Thus, we can represent dates as numbers, where one day counts for (1).
TimeToNum ( time )
This function Converts a time string to a number. Thus, we can represent times as numbers, where one day counts for (1) and one hour for 1/24.
NumToDate ( num )
This function Converts a number to its string date representation.
NumToTime ( num )
This function Converts a number to its string time representation.
DayOfWeek ( date )
This function returns the day of the week (1,..,7) for a given string date.
DayOfWeekStr ( date )
This function returns the day of the week (‘‘Monday‘‘, ...‘‘Sunday‘‘) for a given string date.
DateOf ( datetime )
This function returns the date part of the datetime variable (i.e., returns the integer part).
TimeOf ( datetime )
This function returns the time part of the datetime variable (i.e., return the decimal part)
Month ( date_str )
This function returns 1..12 as the month of the date_str string date
MonthStr ( date_str, mode )
This function returns the month string of the date_str. mode = 1, 2
YearOf ( date_str )
This function returns 1...999999 as the year of the date_str date string.
MonthOf ( date_str )
This function returns 1..12 as the month of the date_str date string.
DayOf ( date_str )
This function returns 1..31 as the month day of the date_str date string.