Change Date to show text 1

[hysonmb]

I have a query that is pulling the month out of a date/time field in a table. How can I make that query show the month as a text "mmm" rather than numeric? I've already got this in my query:

Month: Month([ComplDate])

This pulls the month as a number.

Thanks

 

[nicsin]

Hi hysonmb,

use the format$ like:


strMonth = format$(ComplDate,"mmm&quot


regards,
nicsin

 

[hysonmb]

Thanks for your code, but, it comes back prompting for an entry in strMonth

 

[hysonmb]

Change that last response, thanks for your help, it works.

 

[nicsin]

oops, I thought you were in vba! then use

format(ComplDate,"mmm&quot

in your query.


nicsin