Format Date in another Country

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Format only affects the display of the data. The date and time are store as
a decimal number.
 
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?
 
There should be no problem so long as they enter the date in the format setup
by their Regional Settings of their operating system.
 
Back
Top