MONTH FORMAT

[#1]

hi ,

i wnat to extract  month from

MMM YYYY

format .

what should i do ?

[its_anandrjs]

Write like

Month(YourDateField) //You get Jan, Feb

If you need 01,02,03,04 then write like

Date(YourDateField,'MM') as Month

Or

Date(YourDateField,'MM')

Or

Date(Date#(Left(YourDateField,3),'MMM'),'MM')

[tresesco]

Month(Date#(YourData, 'MMM YYYY')) as Month

[#4]

left('MMMYYYY',3) as month