Format Date in another Country

A

acss

I need to send my DB to south america and the date format from th users
machine is 12/7/2007 instead of the US format 7/12/2007. How can i configure
the date fields to maintain the US format since this affects reports and
calculations?
 
K

KARL DEWEY

Format only affects the display of the data. The date and time are store as
a decimal number.
 
A

acss

Thanks Karl. I have one field that has date() to capture the current date
when an entry is being done. There are also other date fields that need user
input so would you reccomend the user to key in the same format as in their
country so the date calculations would not come up with errors due to default
date 12/7/2007 against a keyed in 7/12/2007? Does it matter?
 
K

KARL DEWEY

There should be no problem so long as they enter the date in the format setup
by their Regional Settings of their operating system.
 
Top