How to tell if a "Month Year" string is in the past or the future

Question

What formula would you use to determine whether a string such as "September 2021" is in the past, present or future? My application needs a checkbox formula to be checked if it is in the past. For instance "August 2021" would be checked since the current month is September 2021. "January 2022" would be unchecked. "September 2021" would be unchecked.

Thank you in advance for your help!

------------------------------
Matt Makris
------------------------------

MichaelTamoush · Answer

Is the current field a text string, and can you be sure it will always be in the same format, and it will be spelled the same?

ie: Will you ever have Sept. 2021 and September 2021 or perhaps Sept 21?

------------------------------
Michael Tamoush
------------------------------

Sign up

Login to the community