I'm having problems storing a date to a SQL database using Database Connectivity Toolset. I'm using 'DB Tools Execute Query.vi' with the query UPDATE [GIVENVALUES] SET [Date] = 2005-01-18 WHERE [GIVENVALUES].[Order_lot_nr] = 'Testar'. Everything works fine except that the wrong date ends up in the database, i.e. 1905-06-10.
I do not have extensive knowledge of the database, but I'm looking at it by importing it to access, and there the data type of the 'Date' column is Date/Time. Does anyone have any idea of the reason of this behaviour?
Regards
//Martin
CLA
https://www.prevas.se/expertis/test--regulatoriska-krav.html
