Formula -- Before current month / Current Month / Future Months / Unscheduled

[romovaro]

HI

I have a Go live column as shown below:

I am struggling to create a formula that can filter:

Before current month (In this case before July 2022)

Current month (In that case July 2022)

Future Months smaller than 01/01/2050 (2050 NOT included)

and if Date = 12/01/3000 = Unscheduled

Example:

6/1/2022	Done
9/1/2022	Pending Scheduled
9/1/2022	Pending Scheduled
11/1/2022	Pending Scheduled
12/1/3000	Unscheduled
12/1/3000	Unscheduled
7/1/2022	Current Month

Any idea?

thanks

[amitchandak · Accepted solution]

@romovaro ,

In case you need a column

Switch( true() ,

[Ops forecast & Acttual] <= eomonth(Today(),-1), "Done",

eomonth([Ops forecast & Acttual],0) = eomonth(Today(),0), "Current Month",

[Ops forecast & Acttual] > eomonth(Today(),0) && [Ops forecast & Acttual]  <date(3000,12,1) , "Scheduled",

 "UnScheduled"

)