Microsoft Access Converting Dates

  • Thread starter Thread starter niceday147
  • Start date Start date
N

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
 
Set the Format property of the text box on your report to:
Long Date
or an explicit format such as:
mmmm dd\, yyyy
 
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access not recognizing Date Format 3
Create List of Dates that fall between 2 Dates 2
Converted from LINUX time ok, but having issues with the between date. 4
date format 2
Count Records and Group by Month 4
Access Running Balance in Access 1
Calculate difference in rows in a query 1
next date?? 1

Back
Top