How to convert number date to text in Access query?

[lylyming977]

Hello,

I need help on how to convert number date to text date.

Ex. Date field: 02/12/2015

convert into:

Month field
February

Day Field
12

Year


2015

Thank you for your help.
Lyly

[JoeM]

Access has MONTH, DAY, and YEAR functions that will return those values from any date field. The only caveat is that these return numeric values.

The only one that might not work for is the month, as it looks like you want the word, and not the number. You can use the FORMAT function for that, i.e.
MonthPart: FORMAT([DateField],"mmmm")

You can also use the FORMAT function to return the Day and Year in Text format, i.e.:

YearPart: FORMAT([DateField],"yyyy")

DayPart: FORMAT([DateField],"d")
or
DayPart: FORMAT([DateField],"dd")
if you want a two digit day (i.e. leading zeroes if day number is less than 10).

[lylyming977]

JoeM- Thank you so much!!!! It works. You are so good!!!

[JoeM]

You are welcome. Glad to help!