yearfrac() Function

Function

yearfrac( start_date, end_date, method )

Determine the fraction of the year.

Keyword	Type	Description
`start_date`	Date	The starting date.
`end_date`	Date	The endng date.
`method`	Date	The methodology, where 0 or omitted is US(NASD) 30/360, 1 is Actual/Actual, 2 is Actual/360, 3 is Actual/365, 4 is European 30/360.

Integer

yearfrac(today(), today() + 270, 3) returns 0.739726

The table below lists this function's compatibility with various features in Appian.

Feature	Compatibility	Note
Portals	Compatible
Offline Mobile	Compatible
Sync-Time Custom Record Fields	Compatible	Can be used to create a custom record field that only evaluates at sync time.
Real-Time Custom Record Fields	Incompatible
Process Reports	Compatible
Process Events	Compatible

Was this page helpful?