Prev: How can I display a Report (Access 2003) on a web page?
Next: Report Missing the Close Button
From: Horse Therapy Horse on 12 Jul 2008 16:56
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!
From: Marshall Barton on 12 Jul 2008 18:18
Horse Therapy <Horse Therapy(a)discussions.microsoft.com>
wrote:

>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

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: How can I display a Report (Access 2003) on a web page?
Next: Report Missing the Close Button