Function: Days360
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
© 2024 Altair Engineering Inc. All Rights Reserved.