Adjust Year function not working as expected

Question

I am trying to do a simple calculation to display the date a person turns 55 years of age. The formula seems pretty straight forward but it is giving an error. For example if DoB is 09-05-1974, QB displays 09/05/2009 instead of 9/5/2029.

ToDate(List("-",ToText(Month([Date of Birth])),ToText(Day([Date of Birth])),ToText(AdjustYear([Date of Birth],55))))

------------------------------
Ketki Ganpule
------------------------------

michaeltamoush · Answer

Adjust year can be applied straight to the date. It will automatically add to the year, and spit the entire date back out. So:

Adjustyear([Date of Birth],55) will yield the date you want. This would be in a formula date field.

------------------------------
Mike Tamoush
------------------------------

ketkiganpule1 · Answer

Thanks Mike! it works perfectly when you keep it simple :)------------------------------Ketki Ganpule------------------------------

Forum Discussion

Adjust Year function not working as expected

2 Replies