Unable to access YEARFRAC excel function
I have a requirement to get difference between two dates in fraction of years using YEARFRAC excel function.
Minimum range of dates can be in days and maximum can go up to 30years (Attached excel with sample data).
Example:
StartDate - 06/01/2022, EndDate - 06/30/2022, Difference in Year = 0.96666666
StartDate - 06/01/2022, EndDate - 3/31/2028, Difference in Year = 0.83333333
I found a post (https://collaborate.pega.com/question/excel-formula-doesnt-calculate-correctly) where Pega team confirmed that YEARFRAC is supported. PR_EngineClasses table also has a record for YearFrac.class. However, there are no references found in 8.6 or 8.7 versions.
Attempted approach : Used DateTimeDifference function to get difference in days and divide by 365. This results an inaccurate value since the range of dates can contain leap vs non-leap years.
Thank you for any response.
***Edited by Moderator Marije to add Support Case Details; update capability tags***
Pegasystems Inc.
GB
@VittalS6 can you confirm that you already logged this as a support incident?
I can see that the ticket is pending ownership.
My internal searches on your issue has not brought up an answer, so our best bet is to wait for our support team to get in touch with you to investigate further.