How to extract month name from a date?

[BigM]

Hi,

Probably really simple but cant find out how anywhere but...how do I extract the month name from a date in a sql query in access.

So I want to extract "May" from this date "06/05/1967" which is in format DD/MM/YYYY.

TIA

 

[ldandy]

Format(YourDate, 'mmmm')

 

[BigM]

Thanks but I have tried that but I get "Undefined Function 'Format' in expression"

SELECT Format(scheduled_date,'mmmm')
FROM View_Scheduled_Actions;

 

[braindead2]

you need to use an alias

SELECT Format([scheduled_date],'mmmm')as datemonth
FROM View_Scheduled_Actions;

or you may have to refresh your references if Access is not recognizing format as a function

 

[jebry]

Hi!

While in the code window, select Tools/References and scroll down the list box to make sure none are marked as missing.

hth
Jeff Bridgham
bridgham@purdue.edu