Code

Re: Fill date field with SQL data using VB.net

Hilary Stoupa — Wed, 02 May 2012 21:12:44 GMT

If you need to know how the XML data is stored, you can always use a form control to enter it (in this instance, a date picker), save the XML, and open the XML with a text editor. Then you can see the actual field values instead of whatever the formatted values are.

Re: Fill date field with SQL data using VB.net

jsherman — Wed, 02 May 2012 20:12:14 GMT

Yay!!! Thank you so much.. I was wondering if it wanted it switched around like that..

Re: Fill date field with SQL data using VB.net

Hilary Stoupa — Wed, 02 May 2012 19:38:35 GMT

Your format if the field is just a date datatype should be "yyyy-MM-dd". If it is a date time, I think it is "yyyy-MM-ddThh:mm:ss".

Fill date field with SQL data using VB.net

jsherman — Wed, 02 May 2012 19:31:37 GMT

Hello.. I have a date field on my form.. I am pulling in a datetime field from a SQL datasource.. When I use VB.net to write the value in the SQL datasource to the Infopath field the value is written as a date and time value and doe snot pass validation for the field. I have tried "tostring("MM/dd/yyyy")" and Infopath still complained it was not a date. Any ideas??