Question

3
Replies
1494
Views
Farookq_MB Member since 2010 5 posts
Galaxesolutions
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed

How to change the pyResolvedDateTimeStamp date format to "DD-MM-YYYY" in Report Definition filter condition?

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.

Low-Code App Development
Moderation Team has archived post
Share this page LinkedIn