Form Date Format

[Guest]

I have built a form, where you put start and stop dates and you then get
information base on those dates. They are entered (on my PC) as 01-01-06 but
I have other PC's that use this form when they try to enter dates they show
as 1/1/6 and the information does not work. Can anyone explain please. The
form is formated to 00-00-00 and short date, so I don't understand why all
computers are not working the same? Thanks

 

[Douglas J Steele]

If you use a named date format such as Short Date, Access gets the
information from whatever the Short Date format has been set to through
Regional Settings in the Control Panel.

You could use "mm-dd-yy" instead of "Short Date" as the format (although you
really should use a 4 digit year...)

 

[Guest]

Thank you I did not know that.

If you use a named date format such as Short Date, Access gets the
information from whatever the Short Date format has been set to through
Regional Settings in the Control Panel.

You could use "mm-dd-yy" instead of "Short Date" as the format (although you
really should use a 4 digit year...)