Forum Discussion

BarbaraAlvarez1's avatar
BarbaraAlvarez1
Qrew Member
5 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
AndrewNelson's avatar
AndrewNelson
Qrew Cadet
5 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
5 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
    5 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's avatar
      BarbaraAlvarez1
      Qrew Member
      5 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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Ok, good to know you have that bookmarked.

        try this

        FirstDayOfYear(AdjustYear(Today(),1))

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