Display Month and Year Only

[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

 

[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

 

[Tara]

Thank you Clifford!

Hi Tara,

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

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

Clifford Bass

 

[Clifford Bass]

Hi Tara,

You are welcome!

Clifford Bass