help with ms access query expression

[kevinh2320]

I have a query with a column called mailOutDate. This field is set to a "ShortDate" format. I'm trying to isolate each part of the date to be used separately in a report. I have successfully used the "left" and "right" expression to isolate the month and year into their respective columns MM and YYYY but, can't figure out how to isolate the Day. Since the Day can be either one or two digits I end up getting a slash for one of the characters when its a single number day.

Any suggestions on how to make this work?

Thanks!

 

[Norie]

Instead of Left/Right why not try using the functions Day, Month and Year?

 

[kevinh2320]

Didn't know about those functions. That worked thank you.