<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Update...</DIV>
<DIV> </DIV>
<DIV>I just tried the same query without parameter binding and it worked
OK.</DIV>
<DIV> </DIV>
<DIV>So I guess my question now is how to insert into a date field using
parameter binding?</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV>Johnny Harris</DIV>
<DIV
style="FONT-SIZE: small; FONT-FAMILY: 'Calibri'; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none; DISPLAY: inline">
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=johnny@southshore.com
href="mailto:johnny@southshore.com">Johnny Harris</A> </DIV>
<DIV><B>Sent:</B> Saturday, October 12, 2013 5:05 PM</DIV>
<DIV><B>To:</B> <A title=valentina@lists.macserve.net
href="mailto:valentina@lists.macserve.net">Valentina Developers</A> </DIV>
<DIV><B>Subject:</B> SQL Insert Date</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-SIZE: small; FONT-FAMILY: 'Calibri'; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none; DISPLAY: inline">
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Hello everyone,</DIV>
<DIV> </DIV>
<DIV>I’m trying to insert a record and one of the fields is a date field.</DIV>
<DIV> </DIV>
<DIV>I get the following error message:</DIV>
<DIV> </DIV>
<DIV>Date Value “10/12/2013” is invalid. Illegal symbol at “-1” position."</DIV>
<DIV> </DIV>
<DIV>Would anyone happen to have any pointers for inserting dates?</DIV>
<DIV>I’m guessing the field is in the wrong format but the format for</DIV>
<DIV>the database is set to “MMDDYYYY” and the separator is “/”.</DIV>
<DIV> </DIV>
<DIV>I’m using .net and parameter binding.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV>Johnny Harris</DIV></DIV></DIV>
<P>
<HR>
_______________________________________________<BR>Valentina mailing
list<BR>Valentina@lists.macserve.net<BR>http://lists.macserve.net/mailman/listinfo/valentina<BR></DIV></DIV></DIV></BODY></HTML>