InfoPath Dev

Well that seem to clear up the error, but its not grabbing the row of data for any data i select from the drop down. I have a feeling is the way it formats the data to (10/26/2010 etc...) so why the number of characters maybe be ok now, it doesn't seem to be converting it to the same format on the next query. Is there away to access these ...

The process would still work. Any idea how to lop off the fractional seconds. Thanks for the reply

[0x80040E07][Microsoft OLE DB Provider for SQL Server] Conversion failed when converting datetime from character string. Hi, Can someone help me please with the above problem. I'm new to InfoPath and i'm trying to make a form that goes into out inventory database (MS-SQL 2005). I have every thing working except this query. The Idea ...