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. ...
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"