Date Function

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

Guest

I have a Querie that pulls the date from a table using a short date. I would
like to see only month and year. Can someone help?
 
Dear LM:

There are functions Month() and Year() that operate on a date to return
those values.

If you want a single column and/or if you want the month's name rather than
number, look at the Format() function.

Tom Ellison
 
Back
Top