Calculating a start date based on current DOB/Age and a target date

Question

Hello:&nbsp; I need assistance in calculating a start date of an action based on current age and a target age.&nbsp; &nbsp;Example:Current age is 64 (dob 2/15/1958)Target age is 65&nbsp;what is the date that is 6 months prior to 65 for a person with dob of 2/15/1958&nbsp;Thank you!------------------------------Barbara Alvarez------------------------------

andrewnelson · Answer

AdjustMonth(AdjustYear([DOB],65),-6)You can replace the 65 with [Target Age] and -6 with -[Months Prior] as needed.------------------------------Andrew Nelson------------------------------

barbaraalvarez1 · Answer

Thank you, I've now found all the date functions!

However, now I can't find a simple calculation/formula to return the first of next year, based on todays date.

I need a date to automatically populate with 01/01/2022 based on today being year 2021.

Appreciate the help!

------------------------------
Barbara Alvarez
------------------------------

markshnier__you · Answer

I won't give you the answer but its super easy.

I will give you a link to all the functions complete with examples. A great site to bookmark for sure

https://login.quickbase.com/db/6ewwzuuj?a=td

btw, did you know that if you are searching in any Quickbase filter box you can use the word AND in upper case (must be upper case).

Try going to that link and filter on

first AND year

... and there will be your answer with examples

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

barbaraalvarez1 · Answer

Thanks, I had looked at these examples before&nbsp; and can get the fist of the year for THIS year, but I need the 1st of the year for NEXT year given whatever the current year is.&nbsp; &nbsp;I am able to get 1 year from todays date, but just need the first of the year&nbsp; for the next year&nbsp; 01/01/2022.&nbsp; &nbsp;I did research before blindly asking for help :)------------------------------Barbara Alvarez------------------------------

markshnier__you · Answer

Ok, good to know you have that bookmarked.try thisFirstDayOfYear(AdjustYear(Today(),1))------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Calculating a start date based on current DOB/Age and a target date

Related Content

Calculation/Performance Limits Inquiry

Calculating 1.5 pay

Calculating number of days between two date fields

Trying to calculate On Time delivery

Average daily active employees calculation