Query Criteria: Converting Date to Display Month Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am in the process of creating a query on a date field and I would like to
take that date and convert it to display the Month only. A sample of how I
can accomplish this task would be appreciated.
 
Use Format([MyDateField], "mmm") to return Jan, Feb, Mar, ..., or
Format([MyDateField], "mmmm") to return January, February, March, ...
 
Back
Top