Forum Discussion
Relative Date formula question
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.
1 Reply
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"
