[quote]Originally posted by KenSchaefer
The "best" way to do this is to:
a) set the LCID for the page to the appropriate locale for the user
b) allow the user to enter their date in their native format (eg mm/dd/yy or dd/mm/yy or dd.mm.yyyy or whatever)
c) format the date into yyyy/mm/dd and insert into the Access database
Some links that may be useful:
Thanks for your tips. During the last year I've created a lot of functions that convert date format into ....well whatever :-)
So I was pretty familiar to you suggestion. Som friends have though suggested that I should use the datadiff method instead.
Well, I have no written my own function that convert the input to US format. And this works perfect at both the Norwegian and the US server :)
I have one question though. When I take a look at the date in my Access base the format is still Norwegian. But the saving and query is working well. Is this because the DB is Norwegian? And is it only the saving of date that have to be in US format?
Einar Hansen, Norway