days360()
Table of Contents
Overview
The days360() function takes startDateTimeValue and endDateTimeValue as arguments. It returns the number of days between the given date-time values.
Note: The daysBetween function can also be used as an alternative to perform the same operation since they behave in the same way.
Return Type
- Number
Syntax
<variable> = <startDateTimeValue>.days360( <endDateTimeValue> );
(OR)
<variable> = days360(<startDateTimeValue>, <endDateTimeValue> );
| Parameter | Description | Data type |
|---|---|---|
| <variable> | Variable which will contain the returned number. | NUMBER |
| <startDateTimeValue> | The starting date-time value. | DATE-TIME |
| <endDateTimeValue> | The ending date-time value. | DATE-TIME |
Note:
Refer this help document to learn about the supported date-time formats.
A runtime error will be encountered if:
- the hour value, or minute value, or second value, is specified in more than 2 digits.
- the date value exceeds the number of days in that month. an incorrect month value is specified.
- the year value has more than 4 digits.
Examples
startDate = '31-Dec-1989';
endDate = '01-Jan-1990';
numberOfDays= days360(startDate, endDate); // returns 1
endDate = '01-Jan-1990';
numberOfDays= days360(startDate, endDate); // returns 1