Agentry server date conversion

[sravanthi_polu]

Hi Experts,

     I have developed a sample customer application in agentry  connecting to mssql back end.There are fields with data type 'date' in front end and data type 'date and time' in back end. In the process of updating orders from ate to back end "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" error has been encountered.Now i have changed 'date' data type to 'date and time'  in front end,now the orders for customer has been updated.Previously the data has been updated with date property in front end,suddenly this issue has been  encountered .Can any one please help to identify what may be the reason for this behavior.Agentry server version is 6.0.30.

Thanks & Regards,

Sravanthi Polu

[Former Member]

Because you are using to different data types (Date and DateTime) you would need to do a convert from the data to the DataTime when you insert the row into the database.  See more information on converting for MS SQL Server here:  http://msdn.microsoft.com/en-us/library/ms187928.aspx

Stephen Streeter