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 dis...
Forum Discussion
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
------------------------------
Adjustyear([Date of Birth],55) will yield the date you want. This would be in a formula date field.
------------------------------
Mike Tamoush
------------------------------
Thanks Mike! it works perfectly when you keep it simple :)
------------------------------
Ketki Ganpule
------------------------------
------------------------------
Ketki Ganpule
------------------------------