days360

days360()

Overview

The days360() function takes startDateTimeValue and endDateTimeValue as arguments. It returns the number of days between the given date-time values.

Return Type

  • Number

Syntax

<variable> = <startDateTimeValue>.days360( <endDateTimeValue> );

(OR)

<variable> = days360(<startDateTimeValue>, <endDateTimeValue> );
ParameterDescriptionData 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

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohodeluge.com