Access Report Dates

H

Horse Therapy

My database shows dates correctly on forms. When I use a report any date
above,
eg. 7/10/2007 shows up as an error. Single numbers in the day section show
up-not double digits. Format is: 99/99/00.
Help!! This is driving me insane!
 
M

Marshall Barton

My database shows dates correctly on forms. When I use a report any date
above,
eg. 7/10/2007 shows up as an error. Single numbers in the day section show
up-not double digits. Format is: 99/99/00.


That looks like the formatting from some other language. In
Access, use m or mm for month, d or dd for day of month and
yy or yyyy for year. I think you want the format to be:
mm/dd/yy
 

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

Top