How to extract Month & Year together from a Date

[shahiq]

Hey guys.... stucked in one thing..... I need to extract Month and Year together from a date in a Query. for example if date is 4/19/2007 i want to put this as April 2007.

Any idea ...?

thanks

 

[Michael J Ross]

To format the output in the query like that,

Format([nameofdatefield],"mmm yyyy")

 

[boblarson]

To format the output in the query like that,

Format([nameofdatefield],"mmm yyyy")

Correction, you would need Format([nameofdatefield],"mmmm yyyy")
otherwise the one Michael showed will only show:

Apr 2007 and not April 2007

 

[Michael J Ross]

Thanks Bob

 

[shahiq]

Thanks Bob

thank you guys....... its working well

 

[boblarson]

Glad to hear.