|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 12th, 2007, 07:10 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Format Date in another Country
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? 
|
|
#2
July 12th, 2007, 07:56 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Format Date in another Country
Format only affects the display of the data. The date and time are store as
a decimal number. -- KARL DEWEY Build a little - Test a little "acss" wrote: 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?
|
|
#3
July 12th, 2007, 08:08 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Format Date in another Country
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? "KARL DEWEY" wrote: Format only affects the display of the data. The date and time are store as a decimal number. -- KARL DEWEY Build a little - Test a little "acss" wrote: 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?
|
|
#4
July 12th, 2007, 08:42 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Format Date in another Country
There should be no problem so long as they enter the date in the format setup
by their Regional Settings of their operating system. -- KARL DEWEY Build a little - Test a little "acss" wrote: 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? "KARL DEWEY" wrote: Format only affects the display of the data. The date and time are store as a decimal number. -- KARL DEWEY Build a little - Test a little "acss" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
