https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/40615.aspxWed, 15 Apr 2009 00:46:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40615Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/40615.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=40615<p>It might be an interesting exercise to add a text box or expression box to the form that is bound to the same field as the date picker -- make sure they don&#39;t have any date formats applied to them, that they just show the XML value.... see if you are getting the&nbsp;&#39;yyyy-mm-dd&#39; format that IP expects...</p>https://www.infopathdev.com:443/forums/thread/40516.aspxFri, 10 Apr 2009 17:48:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40516SethMW0https://www.infopathdev.com:443/forums/thread/40516.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=40516My IP form submits to a SQL Server 2008 datasource. I have fields in my DB that are type &quot;date&quot;. When I add this field to a form, as a date picker control I am getting bizarre behavior. If I type in a date (i.e. 4/10) and move focus to another control the date picker properly formats the date (4/10/2009), but the field is outlined in the dashed red line with a message &quot;only text strings less than or equal to 10 character(s) allowed&quot;, and this obviously prevents submission. However, if I use the date selector button/popup and choose a date, such as &quot;4/10/2009&quot; everything works as expected. Has anyone else run into this? Any suggestions? I also happen to have a varchar(20) field that I mistakenly set up as a date picker on my form, and that behaves as expected. That is, I can type a date, tab out, and IP formats the date, and doesn&#39;t show validation errors. Obviously I can change my database to use just varchar columns, but I&#39;d like to leave them as dates.