Days360 Function

Description

Returns the number of days between the given start date and end date, based on a 360-day year (i.e., 12 30-day months). If method is 0 (or omitted) then the calculation is based on the US (NASD) method; otherwise, it is based on the European method.

Syntax

Days360(startdate,enddate[,method])

Arguments

start date is the name of a field containing start dates, enddate is the name of a field containing end dates or any date, method (optional) is the type of day count basis to use (0 or blank, US; 1, European)

Return value

decoded value

Calculated field example

Calculated Field:

Days360([Ship Date],Today(),)

If the ship date value is 4/10/2010 and today is 11/27/2020

The function returns the following value: 3827