My IP form submits to a SQL Server 2008 datasource. I have fields in my DB that are type "date". 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 "only text strings less than or equal to 10 character(s) allowed", and this obviously prevents submission.
However, if I use the date selector button/popup and choose a date, such as "4/10/2009" 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't show validation errors.
Obviously I can change my database to use just varchar columns, but I'd like to leave them as dates.