Display Month and Year Only


T

Tara

I have a query that pulls referrals we've gotten over the course of time.
Each referral is entered with the date format of mm/dd/yyyy. We're looking
for seasonal trends and so I'd like to have a query that shows me only the
month of the referral in one field (in text form...so July instead of 7) and
another field that gives me the year. What would the expression in the query
be to get the date to format that way?

Thanks in advance
 
Ad

Advertisements

C

Clifford Bass

Hi Tara,

You can use the Format() and Year() functions:

Referral_Month: Format(Referral_Date, "mmmm")
Referral_Year: Year(Referral_Date)

Clifford Bass
 
T

Tara

Thank you Clifford!

Clifford Bass said:
Hi Tara,

You can use the Format() and Year() functions:

Referral_Month: Format(Referral_Date, "mmmm")
Referral_Year: Year(Referral_Date)

Clifford Bass
 
Ad

Advertisements


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

Top