Updating dates in an update query battery dating violence definition
I'm now spending some time to find the cause of the missing milliseconds part of the cell values.The following query reveals the milliseconds by using a CONVERT() function call: r4913 should fix some things on MSSQL: * Microsecond precision is now displayed in table structure editor, in column "Length/Set" * ...
That was one of the saddest few seconds of my life.The reason your updates are not working, Ansgar, is not due to errors with Heidi or ISO format.The problem is caused by time precision in SQL Server." I also live in a d/m/y country, and in 15 years of working with Access have found 3 cases where Access is likely to misunderstand our dates.
Details in: International Date Formats in Access at: the dates are calculated ones, typecasting them in the query can also help: Calculated fields misinterpreted at: Allen Browne - Microsoft MVP. Tips for Access users - to group, rather than allenbrowne at mvps dot org.var microsoft = microsoft