frontpage msacces date format 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,

 

[Tim Ferguson]

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)

You are probably better off asking this is a FrontPage forum rather than an
Access one, because it's not an Access issue.

Presumably somewhere there is some code (jscript, vbs, asp, etc) that is
creating an SQL command that sends the date data to the Jet database. This
code _has_ to convert it into a Jet-legal format, which means either USA
#mm/dd/yyyy# or ISO #yyyy-mm-dd# -- note the # characters and the
separators are not optional. These formats are irrespective of your
national settings: you just don't have a choice.

What you need to do is to identify where and how your data are being
assembled for passing to the database and modify that.

Hope it helps


Tim F