How to extract Month & Year together from a Date (1 Viewer)

S

shahiq

Registered User.

Local time

Yesterday, 21:53

Joined

Mar 31, 2007

Messages

29

• Apr 19, 2007

• #1

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

 

M

Michael J Ross

Registered User.

Local time

Today, 05:53

Joined

Mar 2, 2006

Messages

245

• Apr 19, 2007

• #2

To format the output in the query like that,

Format([nameofdatefield],"mmm yyyy")

 

boblarson

Smeghead

Local time

Yesterday, 21:53

Joined

Jan 12, 2001

Messages

32,059

• Apr 19, 2007

• #3

Michael J Ross said:

To format the output in the query like that,

Format([nameofdatefield],"mmm yyyy")

Click to expand...

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

Apr 2007 and not April 2007

 

M

Michael J Ross

Registered User.

Local time

Today, 05:53

Joined

Mar 2, 2006

Messages

245

• Apr 19, 2007

• #4

Thanks Bob

 

S

shahiq

Registered User.

Local time

Yesterday, 21:53

Joined

Mar 31, 2007

Messages

29

• Apr 19, 2007

• #5

Michael J Ross said:

Thanks Bob

Click to expand...

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

 

boblarson

Smeghead

Local time

Yesterday, 21:53

Joined

Jan 12, 2001

Messages

32,059

• Apr 19, 2007

• #6

Glad to hear.