Last Open Date Field in Search Filter changes if set to 12:00 AM

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

In the search filter for requests/incidents in the date field of the last opening, when placing the time 00:00:00 on the date, it is changing it to 23:59:59, why is this happening?

We see the same problem with all the "Latest" date fields

Latest Time to Violation
Latest Open Date
Latest Resolve Date
Latest Close date
Latest Outage Start Date
Latest Outage End Date
The "Earliest" date fields don't show this same problem.

Also, the "Latest" date fields only show this when setting the time to 0:00 or 12:00 am.  If setting to any other time, we don't see this.

Environment

Release : 17.3

Cause

It is working as designed.

The reason for this is, when you give the date and time as "03/31/2023 12:00AM", the system considers the date and time as "03/31/2023 00:00:00", as the time portion is zeros, we consider to search for the entire time of that day which is 03/31/2023 11:59 pm. 

This is only minute (00:00) in the 24-hour day related to Latest where the comparsion happens with LE (less than or equal to).

Resolution

As a workaround, if you choose one minute before (11:59 PM), or after (12:01 AM) you will not see the same problem.