frontpage msaccess dateformat problem

[reneener]

Hello,

I do have a little big problem. Ive made a form in frontpage with a field
called "enddate" This is send to msaccess to the field "enddate" When i give
in 05-01-2005 it is written in msaccess as 01-05-2005 (I do live in the
Netherlands so i want European format) I've read some articles like the
article from 4guysfromrolla.com but i don't understand how to put it in the
form i created with fronpage. Its a common problem i understand. I
appreaciate your help .

Greetings,

 

[Thomas A. Rowe]

Store the date in Access in a date field, then on your page where you want to display the date, you
have to set the LCID code for the Netherlands. The LCID code controls date and currency formatting.

See:
http://www.codeproject.com/asp/lcid_property.asp

You would have to insert the code in HTML / Code View.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[reneener]

Hello Thomas,

Thanks for your reply!
Ive already did set the session.lcid to 1043 (Netherlands) but that did not
help. It goes rong for the first 12 days of every month.

Greetings,
Renee

 

[Jon Spivey]

That won't help - the LCID sets the format but won't actually change around
the month and day. The safest way is to stick the date in ISO format -
yyyy-mm-dd, ie 2005-05-01. This way there's no room for ambiguity - this is
one of those issues you guys don't have to worry about

 

[Jon Spivey]

Just to make clear I should have said 2005-01-05 for today's date

Jon