Pop-up outlook message invalid date whenever I input max format

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #145974

Pop-up outlook message invalid date whenever I input max format

qa-featured

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.

  1. Let SQL Server handle the conversion of the date/time values by inserting and updating through direct SQL statements.
  2. 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.

Login/Register to Answer

Related Questions