Pulling Month from date field

  • Thread starter Thread starter Susie
  • Start date Start date
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
 
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")
 
Back
Top