Creator Help

Date and Time Functions

Function Description
 <string>.toDate() Returns a date value for a 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>.getSecond() 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>.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>.subMinute() 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
 daysBetween(<start_date>,<end_date)  Returns the number of days between two given dates, based on the 360 day year.
 monthsBetween(strDate,endDate) Returns a number  in the range (1 -    ) representing the number of months between the given start and end dates.
 yearsBetween(strDate,endDate) 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(startdate,nmonth)  Returns a date that is n months away from the start date.
 eomonth(startdate,nmonth)  Returns the last day of the month, n months away from the start date.

Top