Forum Discussion

KetkiGanpule1's avatar
KetkiGanpule1
Qrew Member
3 years ago

Adjust Year function not working as expected

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
------------------------------
Formulas and functions

2 Replies

Sort By
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    3 years ago
    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's avatar
      KetkiGanpule1
      Qrew Member
      3 years ago
      Thanks Mike! it works perfectly when you keep it simple :)

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