All day task due date shows one day in future when using MS-SQL as database

  • 7015125
  • 30-May-2014
  • 20-Feb-2015

Environment

Novell Vibe 3.4

Situation

When using the MS-SQL database with your Vibe install, all day task entries show due dates one day in the future.
This problem does not affect Vibe installs with MySQL or Oracle as database.

Resolution

A fix for this issue is available in the Vibe 3.4 Hot Patch 1, available via the Novell Patch Finder.

Cause

By default, the due date for all day events is stored 1 millisecond before midnight. This date was being rounded off by MS-SQL to the next day.