Help required on Dates over different cultures / locales

[MrMark]

Is there ever a question for which "MS Access" is the correct answer?

[bogeyman]

Is there ever a question for which "MS Access" is the correct answer?

Don't knock it. It brought the power of the relational database and self-build GUI to millions of barely-techy office bods. Quite an achievement really.

Of course it was horrible under the covers, and made database purists wince, but it knocked any other end-user database tool into a cocked hat in terms of power and flexibility.

Quite an acheivement really.

Where is today's MS Access?

[techno]

Surely you would store the date in a DateTime type column which is independent of display format or locale.

Dunno if this helps...

http://www.sql-server-performance.co...e_2008_p1.aspx

http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx

How important is the date? You probably do need to preserve the time zone in which case a DATETIMEOFFSET might do the trick. This might help along with bogeymans links:-

http://books.google.co.uk/books?id=H...um=3#PPA124,M1

http://blogs.msdn.com/bartd/archive/...-datetime.aspx

Thanks guys, will check them out...

[lilelvis2000]

Is there ever a question for which "MS Access" is the correct answer?

A lot of the work I do is in Access. Its a lot more capable than what people think. For one client...its the frontend to their budgeting system with over 3 million rows of data and some sophisticated financial calculations.