Pulling Month from date field

S

Susie

I need a simple thing. How do I pull the month from a
date field in a query. For example, I have a date field
in the table, and I want to create a field in a query that
would read "January" or "February", etc. I know this is
probably very easy....please help...

Thank you for your help.

Susie
 
R

Rick Brandt

Susie said:
I need a simple thing. How do I pull the month from a
date field in a query. For example, I have a date field
in the table, and I want to create a field in a query that
would read "January" or "February", etc. I know this is
probably very easy....please help...

Thank you for your help.
Click to expand...

Format([YourDateField], "mmmm")
 
Top