Hello,

I am using the module ListX 1.9.5 to show a page with a no. of fields.
The following code is used in the format section:

<table width="100%" cellpadding=0 cellspacing=2 border=0 class=Normal>
<tr><td width="25%"></td><td width="75%"></td></tr>
<tr><td>Name</td><td><input name='fld_Name' id=Name type='text'>
<span controltovalidate="Name"
errormessage="This field is mandatory"
display="Dynamic"
evaluationfunction="RequiredFieldValidatorEvaluateIsValid"
initialvalue=""
style="color:Red"> *</span>
</td></tr>
<tr><td>BirthDate</td><td><input name='fld_BirthDate' id=BirthDate type='text'>
<span controltovalidate="BirthDate"
errormessage="This field is mandatory"
display="Dynamic"
evaluationfunction="RequiredFieldValidatorEvaluateIsValid"
initialvalue=""
style="color:Red"> *</span>
<span controltovalidate="BirthDate"
errormessage="Input is incorrect dd-mm-yyyy"
display="Dynamic"
evaluationfunction="RegularExpressionValidatorEvaluateIsValid"
validationexpression=
"(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\d\d"
initialvalue=""
style="color:Red;display:none"> (Only a correct date: dd-mm-yyyy)</span>
</td></tr>
<tr><td><br></td></tr>
<tr><td colspan="1">
<a onclick="if (typeof(Page_SmartValidate)=='function') return Page_SmartValidate();"
language="javascript"
{ACTION,RecUpdate,RecUpdate,,Message}>Send</a>
</td></tr>
</table>

The following code is used in the action section to save the record in SQL:

INSERT INTO CheckTable (Name,BirthDate)
VALUES ('@Name', [FORMAT,[@BirthDate],{0:dd/MM/yyyy}])


The problem occures when saving the date. The input is 01-06-2009 (first of June) and the following date is saved in SQL: 1894-06-27 00:00:00

How can I use formatting to save 01-06-2009 in the correct way.

Thanks in advance.

Best Regards,
Elwin.