Anyone one have any help on this one? @cheonsasolution was 99% there, until I got some additional feedback see example below:
EX:
Today's Date= 11/02/2022
DOB: 10/22/2020
Returned value should be = 2.0 (2 years + less than 1 month - Correct)
The formula above returns: 2.1 (2 years + 1 month - Incorrect)
ScheduledDate (always in the future): 11/21/2022
Returned Value = 0.-1
Should be returning: 2.1 (2 years + 1 month - won't change to 2.2 until 12/23/2022)
IF:
ScheduledDate (always in the future): 12/23/2022
Returned Value = 0.-1
Should be returning: 2.2
This the formula I use in Excel, but I can't translate it for use in Caspio:
=IF(ISBLANK(ScheduledDate),"",DATEDIF(DOB,ScheduledDate,"Y")&"."&DATEDIF(DOB,ScheduledDate,"YM"))
So based on the above both formulae need to be updated:
DOB = 10/22/2022
Age (in years and months: 2.0
Age at time of services (in years and months
2.0 for 10/22/2022 - 11/22/2022
2.1 for 11/23/2022 - 12/22/2022
2.2 for 12/23/2022 - ...