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
 
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
Click to expand...
 

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

VBA - exporting serial letters to single documents 0
Creating a Search using a combo box and then creating a report. 4
Combining Date queries 3
query to show where no data in a stated column 0
extract just month/year from table field?? 2
How to add day to PWA 2016 date format? 0
Year as well as month in formula 3
Month and Year only 0

Top