Clarity

We have a scenario where the INV_INVESTMENTS.schedule_finish field does not match between a Clarity view and what is stored in the SQL Server database.  In the view, the date is "12/14/2015 12:00 AM" and in the database it is "2015-12-15 00:00:00.000".  This is occurring on a view on the Idea object.  We have Clarity version 14.3.  Please reply if you have seen this or have any advice.

This has come up a few times - I guess you would describe it as a "feature" of the way Clarity handles the finish date!

See ; Project Finish Date in Clarity

and  Q: Planned Cost Finish - different valude displayed in Clarity / Database ?

COP_CALC_FINISH_FCT Function

for some discussion around this.

(bottom line - Clarity is "right", reading the data directly off the database is "wrong")

COP_CALC_FINISH_FCT is the database function that "converts" the database-date to the Clarity-date