Date and Time Functions
The following topics present date and time functions provided by the CALC object. Each CALC function returns the same result as the Excel function of the similar name.
|
Many date functions include an optional parameter basis to indicate the day count convention:
|
-
CALC.fiscalyear445(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalyear454(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalyear544(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalquarter445(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalquarter454(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalquarter544(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalmonth445(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalmonth454(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalmonth544(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalweek445(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalweek454(date, startYear, startMonth, startDay, leapYears[,timeZone])
-
CALC.fiscalweek544(date, startYear, startMonth, startDay, leapYears[,timeZone])