Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In my Cease MonthYear table having like this:
Cease MonthYear
40544
40575
40603
I write in my scrip
month(Num#([Cease MonthYear],'MM-YYYY')) as [Cease MonthYear],
byt it display only month Jan, Feb.....
I want Jan 2011, Feb 2011.... like this how can i get it?
Thanks
Madhu
Date([Cease MonthYear],'MMM-YYYY') as [Cease MonthYear],
Or,
MonthName([Cease MonthYear]) as [Cease MonthYear],
Date([Cease MonthYear],'MMM-YYYY') as [Cease MonthYear],
Or,
MonthName([Cease MonthYear]) as [Cease MonthYear],