Date and Time Functions

FunctionDescription
 <string>.toDate()Returns a date value for an input text
 <string>.toTime()Returns a date-time value for an input text
 <datetime>.getDay()Returns the date of the month for the given date
 <datetime>.getDayOfWeek()Returns a number in the range (1 - 7), representing the number of the day of the week, that date falls. The number "1" represents Sunday, "2" represents Monday and so on.
 <datetime>.getMonth()Returns the numerical value of the month from the date specified
 <datetime>.getYear()Returns the numerical value of the year from the date specified.
 <datetime>.getWeekOfYear()Returns a number in the range (1 - 52), representing the number of the week in the year. For example, "16/1/2007" returns 3..
 <datetime>.getDayOfYear()Return a number in the range 1-365, representing the number of the day of the year that date falls.
 <datetime>.getHour()Returns the hour value alone from the time specified.
 <datetime>.getMinutes()Returns the minute value alone from the given time
 <datetime>.getSeconds()Returns the seconds from the given date/time. 
<datetime>.addDay()Returns a date-time value after adding the specified number of days.
<datetime>.addWeek()Returns a date-time value after adding the specified number of weeks.
<datetime>.addMonth()Returns a date-time value after adding the specified number of month
<datetime>.addYear()Returns a date-time value after adding the specified number of years
 <datetime>.addHour()Returns a date-time value after adding the specified number of hours.
 <datetime>.addMinutes()Returns a date-time value after adding the specified number of minutes. 
 <datetime>.addSeconds()Returns a date-time value after adding the specified number of seconds. 
 <datetime>.subDay()Returns a date-time value after subtracting the specified number of days. 
 <datetime>.subWeek()Returns a date-time value after subtracting the specified number of weeks. 
 <datetime>.subMonth()Returns a date-time value after subtracting the specified number of months. 
 <datetime>.subYear()Returns a date-time value after subtracting the specified number of years. 
 <datetime>.subHour()Returns a date-time value after subtracting the specified number of hours. 
 <datetime>.subMinutes()Returns a date-time value after subtracting the specified number of minutes. 
 <datetime>.subSeconds()Returns a date-time value after subtracting the specified number of seconds. 
 <datetime>.addBusinessDay()Returns the last working date from the start date specified, depending upon the number of days.
 nowReturns the current time
 todayReturns the current date
 days360(<start_date>,<end_date) Returns the number of days between two given dates.
 monthsBetween(<start_date>, <end_date>)Returns a number  in the range (1 -    ) representing the number of months between the given start and end dates.
 yearsBetween(<start_date> ,<end_date>)Returns a number  in the range (1 -    ) representing the number of years between the given start and end dates.
 toStartOfWeek Returns the starting date of the week, for a given date
 toStartOfMonth Returns the starting date of the month, for a given date
 edate(<start_date>,<nmonth>) Returns a date that is n months away from the start date.
 eomonth(<start_date>,<nmonth>) Returns the last day of the month, n months away from the start date.