This content has been marked as final. Show 3 replies
I have below script work fine :-
SubField([Expected Close Date],'-' ,3) as Year,
Now i need to create month_n field :-
(year(today()) - year(@50:60T)) * 12 + month(today()) - month(@50:60T) + 1 as Month_n,
But above script return no value.
The purpose of month_n is allow me select
month_n = 0 , that is current month.
month_n = 1 , that is Next month
Can some one help me.