Skip to main content
Question

Adjust Year function not working as expected

  • August 9, 2021
  • 0 replies
  • 37 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14
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
------------------------------
Terms & ConditionsAccessibility statement