yearfrac( start_date, end_date, method )
Determine the fraction of the year.
Keyword | Type | Description |
---|---|---|
|
Date |
The starting date. |
|
Date |
The endng date. |
|
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
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 | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
Process Reports | Compatible | |
Process Events | Compatible |
yearfrac() Function