Skip to main content
Question

Formula that incrementally adds 3 months to a [static date] until it is greater than or equal to [date created].

  • July 20, 2022
  • 0 replies
  • 180 views

Hello! 
I am trying to create a field that essentially looks at a [static date] (which will always be in the past), and have it add on 3 months incrementally until the MM/YYYY eventually is greater than or equal to MM/YYYY of [date created]. Once the above has been marked as true, I would like that manipulated static date displayed in the field type on the form.

Example: [static date = 1/1/2021], [date created = 8/1/22]
April 2021 >= August 2022 , FALSE ..... July 2021 >= August 2022 , FALSE ...
... eventually getting to ...
October 2022 >= August 2022, TRUE
Posted in the field would be 10/1/22

Thank you in advance to the highly intelligent being that figures this out

------------------------------
Shane Miller
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Shane, are you asking for this.

When the Static Date plus 3 months is greater than the Date Created show the Date Created plus 1 month, else blank?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------