Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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
etc
.
Can some one help me.
Paul
Try this?
=(year(today()) - year(Date#([Expected Close Date],'MM-DD-YYYY'))) * 12 + month(today()) - month(Date#([Expected Close Date],'MM-DD-YYYY')) + 1 as Month_n
My QVW
Try this?
=(year(today()) - year(Date#([Expected Close Date],'MM-DD-YYYY'))) * 12 + month(today()) - month(Date#([Expected Close Date],'MM-DD-YYYY')) + 1 as Month_n
Hi Anil
Thank you
Paul