When creating Other Work by Xog/manual UI update the Finish Date value is not updating consistently

Products

• Clarity PPM SaaS

Issue/Introduction

The Finish Date of Other work is not getting audited correctly. The Finish Date value appears perfectly fine from application side in Audit Trail. The value stored in cmn_audits table in database is incorrect (increased by 1) whenever date has timestamp of 12:00 AM. It seems to be different from midnight rule as the issue is not consistent. Sometimes database takes the timestamp of 00:00:00 and other times it takes timestamp of 17:00:00 randomly. It subtracts the date by 1 day only when there is timestamp of 00:00:00 and other times it takes same day and set teh time stamp as 17:00:00.

Environment

Release : 16.0

Component : CLARITY XML OPEN GATEWAY (XOG)

Resolution

Engineering disposition on the behavior is working as expected (Not a bug). While xogging the 'other work' object when setting the finish date to "2022-01-27T00:00:00" it is stored in the database the same way.
The finish field in UI is of type date, and you can configure it to show date and time (time is displayed in the intervals of 15mins). If you observe the hour field there is no 0 hour in the drop down either, it is 12AM or 12PM. So the UI is displaying "2022-01-27T00:00:00"  as "1/26/2022 12AM :00" (If you configure the finish field as date and time you can see it). Both '26th 12AM' and '27th 00hour' are same this seems to be not a bug. This behavior is same in projects as well.