Microsoft Access Converting Dates

[niceday147]

Hello,

I am a new user to microsoft access and I am having problems transferring
dates into the correct format. The dates appear in tables as 01, 02, 03 etc
for the months. I need these to be displayed in the query results and the
reports as January, February, March etc.

Does anyone know how to do this?

Thanks for your help

Ross

 

[Allen Browne]

Set the Format property of the text box on your report to:
Long Date
or an explicit format such as:
mmmm dd\, yyyy

 

[Duane Hookom]

It seems that you have a text field storing the month number. If this is the
case, you can convert this to a month name using the MonthName() function.

=MonthName([YourFieldNameHere])