My month_n script is not working ?

[paulyeo11]

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

[paulyeo11]

My QVW

[Anil_Babu_Samineni · Accepted solution]

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

[paulyeo11]

Hi Anil

Thank you

Paul