Date format

[#1]

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

[tresB · Accepted solution]

Date([Cease MonthYear],'MMM-YYYY') as [Cease MonthYear],

Or,

MonthName([Cease MonthYear]) as [Cease MonthYear],