ShaneMiller1
3 years agoQrew Cadet
Formula that incrementally adds 3 months to a [static date] until it is greater than or equal to [date created].
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
------------------------------
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
------------------------------