Date format

Fri, 16 Oct 2015 07:59:29 GMT

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

Re: Date format

tresB — Fri, 16 Oct 2015 08:07:06 GMT

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

Or,

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