Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Madhusudan Sharma (MadhusudanS9253)
Coforge DPA private limited
Technical Architect
Coforge DPA private limited
AU
MadhusudanS9253 Member since 2015 38 posts
Coforge DPA private limited
Posted: Feb 4, 2018
Last activity: Feb 12, 2018
Posted: 4 Feb 2018 10:39 EST
Last activity: 12 Feb 2018 3:59 EST
Closed

HOW TO CONVERT DATETIME TO DATE IN REPORT DEFINITION

Hi,

I want to convert datetime say current datetime to date(need date part only). Not able to do via function alias also, can someone help me on this.

Thank in advance.

***Moderator Edit: Vidyaranjan | Updated Categories***

To see attachments, please log in.
Reporting
User Experience

Posted: 7 years ago
Posted: 4 Feb 2018 13:31 EST
Thenuzan Sriskanthan (Thenuzan)
OCBC
Pega Developer
OCBC
SG

Hi Madhusudan,

Please refer below  images.

Use configuration icon in column to configure date format.

To see attachments, please log in.
  • Preethi Ageer Venkat Raman Malaiarasan Shane Soderstrom Varsha Junuthula
Posted: 7 years ago
Posted: 4 Feb 2018 13:57 EST
Madhusudan Sharma (MadhusudanS9253)
Coforge DPA private limited
Technical Architect
Coforge DPA private limited
AU

Thanks Thenzun, but I am actually taking difference of two datetime value...which is giving me results by calculating time also but I need it to calculate only the days, meaning if I compare todays date and yesterday date difference should be one but it is taking time parameter also and if the difference is < 24 it is returning 0.Please see the attachment where I am using function where in these two parameters are of date time type. so I need to convert these two into dates and then find the difference.

Thanks again.

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 9 Feb 2018 11:14 EST
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

HI Madhu,

I had tried the similar use case in Pega 7.2.2 environment and it is returning the value 1 even though difference is <24 hr as shown in attachment.

Regards

Mahesh

To see attachments, please log in.
Posted: 7 years ago
Posted: 11 Feb 2018 3:14 EST
Madhusudan Sharma (MadhusudanS9253)
Coforge DPA private limited
Technical Architect
Coforge DPA private limited
AU

Thanks Mahesh.

 

That means this function is working absolutely fine in your case. I mean it is taking server's timezone and calculating accordingly?

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice