Question

3
Replies
1690
Views
Mohammad Farookq (Farookq_MB)
Galaxesolutions
TL
Galaxesolutions
IN
Farookq_MB Member since 2010 6 posts
Galaxesolutions
Posted: May 29, 2018
Last activity: May 30, 2018
Posted: 29 May 2018 21:46 EDT
Last activity: 30 May 2018 2:34 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.