Date Field

[Shri]

Hi,

I have a DB on the share drive. The DB has few date fields and are formated
as 00/00/00. When I access the DB from my PC and input the date field as
08/01/2008 it stays the same. But when user from SriLanka access the DB and
input the date field 08/01/2008, the DB is truncating the 0's and input the
date as 8/1/2008.

Since the date field is formatted if I input the 8/1/2008 I get error
message saying that the date format is not correct. But the SriLanka user
doesn't get this error mssg. We both are accessing the same DB. Is there
any reason the DB truncating 0's for offshore users.

I have some VBA code tied to the date fileds and the SriLanks users were
getting the error mssge because the date 8/1/2008 is not identified by the
code.

Thanks in advance.

 

[Jeff Boyce]

Important to keep in mind that the Access Date/Time field stores data as
#####.#####, not as a string that looks like a date/time.

You manage that with the format you chose for display.

It almost sounds like you are describing an Input Mask (how data must be
entered), rather than a format (how data is displayed).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Shri]

I defined the input mask for all the date fields. So that the users doesn't
input in different ways. The strange thing is the date looks like 08/01/2008
on my PC, but for Srilanka user the date looks like 8/1/2008. I am not sure
why.

Thanks.

 

[KARL DEWEY]

A mask is how you have to input the data and does not control the output
display.
The first thing that controls the display for a date is Windows Regional
Settings.
Next is formatting of the output in a query, form or report.

 

[Shri]

Windows Regional settings is it in the Access DB or on PC.
Can you please let me know where to look for Windows Regional settings.

Thanks.

 

[John W. Vinson]

Windows Regional settings is it in the Access DB or on PC.
Can you please let me know where to look for Windows Regional settings.

It's in Windows; Start... Control Panel... Regional and Language Settings.

 

[KARL DEWEY]

Control Panel
Regional an Languages Options
Edit the display of how you want Short Date & Long Date to look.

 

[GuidoNTS]

I have the same difficulty.

My pc is set for Dutch, so the date is like 01/mei/08. But I have to make a
database where all the input is in English. So the date is like 01/may/08.
Can I change the language from Dutch to English just for that database?

Guido