Date Format

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have a report that one of the fields is a date and on my
computer the report will be for example 12/31/03 but on a
different computer it will be 12/31/2003. I have the
field as a Short Date with Input mask ##/##/##. Why is it
showing the full year on the other computer?

Thanks,

Steven.
 
I have a report that one of the fields is a date and on my
computer the report will be for example 12/31/03 but on a
different computer it will be 12/31/2003. I have the
field as a Short Date with Input mask ##/##/##. Why is it
showing the full year on the other computer?

Thanks,

Steven.
Click to expand...

The short date format will be whatever the short date system format is
for each computer.
If you wish a 2 digit year shown, set the Format property (not the
Input Mask) instead to
mm/dd/yy

To change the Regional short time settings go to:
Start + Control Panel + Regional and Language Options
 
Back
Top