Report Date Formatting

L

Lon

My report date formatting is mm/dd/yy which would give me 11/18/08.
Something has changed because it now gives me 11/18/20. If I lengthen the
field it will show 11/18/2008. I don't have room for 10 characters. So what
is the easy way to get the date to show in mm/dd/yy format.
 
F

fredg

My report date formatting is mm/dd/yy which would give me 11/18/08.
Something has changed because it now gives me 11/18/20. If I lengthen the
field it will show 11/18/2008. I don't have room for 10 characters. So what
is the easy way to get the date to show in mm/dd/yy format.

On the Format Property line of the control write:

mm/dd/yy
 
L

Lon

More of the story. When I run the application on another PC it shows the
date as mm/dd/yy or 11/18/08. Since the application is the same running on
XP and Access 2003 why does it show 08 on other PC's and 20 on mine?
 
L

Lon

The format property in the report is mm/dd/yy. In further testing I found
that it works OK on some of my users PC's but not mine. See my repsonse to
myself.
 
L

Lon

OK, I found the answer.

If you go to Tools, Options, use four-digit year formatting and uncheck This
database and All databases then the date will show as 11/18/08 rather than
11/18/2008.

We have over 30 PC's using my Access databases and most of them displayed
the date as 11/18/08 while mine showed it as 11/18/2008 (or 11/18/20 since my
field size was to short to show it all). There are only a couple of PC's
that acted the same as mine. There must be a Windows date formatting that
overrides my Access formatting. But I don't have time to check this out.
I'm changing my Tools, Options formatting to just show the two digit years.
 

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