Relative Date formula question

[Anonymous]

Hi, I have this Relative Date custom column.

However, it is treating October as "Past". I want October to be marked "Future" since it is not over yet.

How should I correct the formula?
Thanks.

[amitchandak]

@Anonymous , This can work if Fiscal Month is date

Use fiscal month end date or date

if [date]>  DateTime.Date(DateTime.FixedLocalNow())  then "Future" else "Past"