hi all,
I'm having some difficulties converting a sql date back to a date that infopath can use. The date in Sql server is 2011-03-01 00:00:00:000
I'm trying to convert this to DateTime back into an infopath datepicker field but it's giving me an error of "Schema validation found non-data type errors."
my code is this:
nav.SelectSingleNode("/my:myFields/my:sLayout/my:dpExpirationDate", NamespaceManager).SetValue(Convert.ToDateTime(reader("ExpirationDate")))
I want the date stored in sql server to be populated in my infopath form in a datepicker field.
My research found that this error can be caused if the value is nil in the database, however, there is clearly a date and time in the sql field.
I've tried converting the data using CDate, etc without success. Can someone point me in the right direction?
thanks