LE type comparison of search dates,

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

How is done the LE type comparison of search dates ?

 

Environment

Release : 17.2

Component : SERVICE DESK MANAGER

 

Resolution

This is the behavior by design of the search Dates.

Assuming web.cfg has DD-MM-YYYY hh:mm:ss.

For LE type comparison of search dates, if you don't specify time like "01-07-2020" in a Latest Date field, webengine (freeaccess.spl) reads it as 01-07-2020 00:00:00 and then converts date to 01-07-2020 23.59.59.

When the comparison is LE,  it is assumed the user means compare by days and add 23:59:59 to the Latest Date field before stuffing it.

This is the expected behavior.

Similarly even if you provide "01-07-2020 00:00:00" in a Latest Date field, it gets converted to 01-07-2020 23.59.59 for LE type comparison.