Forum Discussion

Del's avatar
Del
Qrew Cadet
6 years ago

Status Field based on date

In need of a formula status field that will be used to highlight a record based on the date field "Action Date" being within the current month. Example, If Action Date is not within current month then...
Formulas and functions
BrandonDrake's avatar
BrandonDrake
Qrew Cadet
6 years ago
Hello Ermias, 

Would something like this work? 

if(not isNull([Action Date]) and ([Action Date] >= FirstDayofMonth(Today()) and [Action Date] <= LastDayOfMonth(Today())), "Completed", "Not Completed")

------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
  • Del's avatar
    Del
    Qrew Cadet
    6 years ago
    Thanks, works

    ------------------------------
    Ermias Bean
    ------------------------------