Forum Discussion

BarbaraAlvarez1

Qrew Member

4 years ago

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

Hello: I need assistance in calculating a start date of an action based on current age and a target age. Example: Current age is 64 (dob 2/15/1958) Target age is 65 what is the date that is...

Formulas and functions

Qrew Cadet

4 years ago

AdjustMonth(AdjustYear([DOB],65),-6)

You can replace the 65 with [Target Age] and -6 with -[Months Prior] as needed.

------------------------------
Andrew Nelson
------------------------------

BarbaraAlvarez1
Qrew Member
4 years ago
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
  Qrew Champion
  4 years ago
  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
    Qrew Member
    4 years ago
    Thanks, I had looked at these examples before 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. I am able to get 1 year from todays date, but just need the first of the year for the next year 01/01/2022. I did research before blindly asking for help :)
    
    ------------------------------
    Barbara Alvarez
    ------------------------------