Date Format

S

Steven

I have the date formatted as ShortDate in a form but when one of the users
opens the form on their computer it shows as 08/31/2005 for example. Why is
this? How do I make the form override whatever that computer is doing so the
date will show 08/31/05.

Thank you,

Steven.
 
R

Rick Brandt

Steven said:
I have the date formatted as ShortDate in a form but when one of the
users opens the form on their computer it shows as 08/31/2005 for
example. Why is this? How do I make the form override whatever that
computer is doing so the date will show 08/31/05.

Thank you,

Steven.
Click to expand...

The "Named" formats (short, long, medium, etc..) are dependent on the individual
settings on each PC. If you want a consistent format in your app then don't use
the named ones. Use an explicit format string like "mm-dd-yy".
 
O

Ofer

I have the date formatted as ShortDate in a form but when one of the users
opens the form on their computer it shows as 08/31/2005 for example. Why is
this? How do I make the form override whatever that computer is doing so the
date will show 08/31/05.

Thank you,

Steven.
Click to expand...
 
Top