Date handling in Data tab with MSSQL (bug?)

[expired user #8500]'s profile image [expired user #8500] posted 9 years ago in General Permalink
If I use the Data tab to change a date or datetime field in a MSSQL table, the day and month values are reversed!
For example, if I change a date to '2013-04-11', it ends up as '2013-11-04'. The SQL log shows an update query where the date value is set to '04/11/2013', which the server obviously misinterprets.

This was with v. 9.1.0.4867, 64-bit. I tried it with my older installation, v. 8.0, 32-bit (with the same database), and it sets the date to the 'yyyy-mm-dd' format, which works.
ansgar's profile image ansgar posted 9 years ago Permalink
Please read and report that in this thread

Please login to leave a reply, or register at first.