days360_days_difference_based_on_360_day_year_.htm
| Navigation: Templates > Guide to all Templates > Additional Libraries and Templates > Finance Library >====== DAYS360 (days difference based on 360-day year) ====== |    |
DAYS360(startdate,enddate)
| DAYS360 | Computes the difference in days, between two given dates. |
| startdate | A numeric constant or variable containing the beginning date. |
| enddate | A numeric constant or variable containing the ending date. |
DAYS360 determines the number of days difference between a beginning date (startdate) and an ending date (enddate), based on a 360-day year (30 day month). Both date parameters MUST contain Clarion standard date values.
Return Data Type: LONG
Internal Formulas:
DAYS DIFFERENCE = ending date - beginning date
where:
ending date = 360(year) + 30(month) + z
z = 30 if ending date = 31 and beginning date > 29
z = ending date if ending date <;> 31 and beginning date <; 29
and:
beginning date = 360(year) + 30(month) + z
z = 30 if beginning date = 31
z = beginning date if beginning date <;> 31
Example:
DaysDifference = DAYS360(StartDate,EndDate)
days360_days_difference_based_on_360_day_year_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1