Forum Discussion

BarbaraAlvarez1's avatar
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 6 months prior to 65 for a person with dob of 2/15/1958 

Thank you!


------------------------------
Barbara Alvarez
------------------------------
Formulas and functions

5 Replies

Sort By
  • AndrewNelson's avatar
    AndrewNelson
    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's avatar
      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------