Free cookie consent management tool by TermsFeed yearfrac() Function
yearfrac() Function

Function

yearfrac( start_date, end_date, method )

Determine the fraction of the year.

Parameters

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.

Returns

Integer

Examples

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

Feature compatibility

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

yearfrac() Function

FEEDBACK