Solution found

R

Rene Wennekes

Replaced Date() in Value

with

<input type="text" name="datum"
value="<%=Day(Now)%>/<%=Month(Now)%>/<%=Year(Now)%>">

Rene Wennekes
 
S

Stefan B Rusynko

But that relies on your users re-entering a date in the form DD/MM/YY
- many will not

Make the form w/ 3 fields for DD MM and YY
<input type="text" name="datumDD" value="<%=Day(Now)%>">&nbsp;
<input type="text" name="datumMM" value="<%=Month(Now)%>">&nbsp;
<input type="text" name="datumYY" value="<%=Year(Now)%>">

Then process the 3 form fields to generate a valid date to send to the DB
datum = Request.Form("datumDD & "/" & Request.Form("datumMM & "/" & Request.Form("datumYY")
- or what ever date format you are using

As w/ any date data entry you need to check for invalid dates to prevent DB errors



| Replaced Date() in Value
|
| with
|
| <input type="text" name="datum"
| value="<%=Day(Now)%>/<%=Month(Now)%>/<%=Year(Now)%>">
|
| Rene Wennekes
|
|
 
Top