Asked By
Tikwa Zuph
0 points
N/A
Posted on - 05/01/2013
I am using SQLSetPos from Microsoft to input and update my time zone. But whenever I input maximum format for my time, the outlook message invalid date shows up. Did I miss something from my setting to improve my desired time format?
Pop-up outlook message invalid date whenever I input max format
Hi Tikwa Zuph,
  The error is caused by an algorithm that converts the date/time that is not rolling the hours part of the time over the days part of the date. In that case the time would have a lot of values which also intervenes in showing the correct date.
    A hotfix will be available on the next Microsoft Data Access Components service pack. However, there are two potential workarounds in the meantime.
-
Let SQL Server handle the conversion of the date/time values by inserting and updating through direct SQL statements.
-
Instead of using datetime, you can define the fields as smalldatetime if storing milliseconds is not necessary. This only uses 4 bytes for storage and does not have millisecond precision.