| Function | Description |
| <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. |
| now | Returns the current time |
| today | Returns 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. |
