Date and Time Functions

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.
toStartOfWeekReturns the starting date of the week, for a given date
toStartOfMonthReturns 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.

Share this post : FacebookTwitter