Date Function

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?
 
T

Tom Ellison

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date serial for 2 months prior 2
Help with a date Expression 6
Year to date month/year 1
Query for previous week, Sun thru Sat, from date field 1
using a rolling date range to sum 1
Previous Month in query 1
Format DATETIME to Date in query on linked table 4
date function 3

Top