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

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?

• Status: Open
• Question Views: 902
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Message Queue

Answered By Davidson Mudge 0 points N/A #145974

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.

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.

About Davidson Mudge

Questions
3

Answers
500

Best Answers
197

• Vote Up 0 Vote Down

• Posted on - 05/08/2013
• Question Category: Message Queue