Hi All,

How to change the pyResolvedDateTimeStamp date format to "DD-MM-YYYY" in Report Definition filter condition? Is there any existing functionality which we can reuse? I tried with couple of FormatDateTime() , To_Date(), GetDate() functions but some how not getting required output. I need to compare pyResolvedDateTimeStamp with other date.

Appreciate if anybody provide me required right method.

Example :

pyResolvedDateTimeStamp = "5/30/2018 7:45 AM" and DT_OF_RETURN="25MAY,2018" want to convert these 2 dates in correct format and compare.