AnsweredAssumed Answered

How do I calculate non-rounded whole elapsed years?

Question asked by basilisk2 on Sep 2, 2013
Latest reply on Sep 3, 2013 by philmodjunk

Title

How do I calculate non-rounded whole elapsed years?

Post

     I have a date and need to calculate how many whole years have elapsed since that time. I don't want the months or days, just the number of whole years as an integer (so that I can add '1' to the result to give the number of the next anniversary eg 2 full elapsed years + 1 = "Your next anniversary will occur on the (date of anniversary) and will be your third anniversary".

     Can you please help? I tried doing a Calculation but  couldn't find "Today" or even Get (CurrentDate) which is referenced all through these forums but is not in my FMPA 11 help guide or function list.

     All suggestions welcomed!

Outcomes