Date and Time predefined functions

 

DateToNum ( date )

 

This function Converts a date string to a number. Dates can represented as numbers, where one day counts for (1).

 

TimeToNum ( time )

 

This function Converts a time string to a number. Times can represented 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 (ie returns the integer part).

TimeOf ( datetime )

This function retrurn the time part of the datetime variable (ie 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 retrurns 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