Between 1st and 12th each month webforms swap the date wrong to access database

R

Rene Wennekes

We have a small database on a intranet server in the Netherlands.
Automaticly a webform should send the date to a access database

<input type="text" name="datum" value="<%=date%>">

but between the 1st en 12th each month the date in the database is wrong (1
Jan, 1 Feb.....).

On the server country is Netherlands, date format = dd,mm,yyyy etc. etc.
Page code of the webform is Netherlands (LCID = 1043). Everything tried
......

What is wrong?

With kind regards,

Rene
 
J

Jim Buyens

Most likely, something in OLEDB or the Microsoft Access "Jet" drive is using
a US date format.

In most cases, the best work around is to give the visitor separate text
boxes or drop-down lists for month, day, and year, and then combine them in
the order the database drivers want. For example:

<input type="hidden" name="datum">
<input type="text" name="datdd">
<input type="text" name="datmm">
<input type="text" name="datyy">

<input type="button"
onclick="document.forms[0].datum.value=document.forms[0].datmm.value + '/' +
document.forms[0].datdd.value + '/' + document.forms[0].datyy.value;
document.forms[0].submit();">

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top