date format

[Shashi Kiran]

how do I ensure the date be stored in one format without
any dependance of the regional settings of the client

 

[John Vinson]

how do I ensure the date be stored in one format without
any dependance of the regional settings of the client

The date is not stored in ANY format. It's stored as a Double Float
number, a count of days and fractions of a day (times, i.e. 0.25 is
6:00am) since midnight, December 30, 1899.

To ensure that it is *displayed* in your preferred format in your
forms or reports, set the Format property of the textbox to an
explicit format, e.g. mm/dd/yyyy or dd-mmm-yyyy (rather than using
Short Date or Long Date, which obeys the regional settings).

 

[Allen Browne]

With 11 years developing in Access outside the US date format, we have found
3 cases where Access can misunderstand your dates.

They are outlined in this article:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html