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

 Stalin Arockiam (Stalin Arockiam)
Bank of New Zealand
Senior System Architect
Bank of New Zealand
IN
Stalin Arockiam Member since 2011 3 posts
Bank of New Zealand
Posted: Jun 12, 2017
Last activity: Jun 22, 2017
Posted: 12 Jun 2017 20:29 EDT
Last activity: 22 Jun 2017 19:54 EDT
Closed

How to find Months and remaining days between 2 dates

Is there any function/logic to find a Months and Days between 2 dates.

Ex:

StartDate EndDate Expected Result Comments
15/04/2018 15/04/2018 0 Months 1 Day Count starts from Startdate as 1 day
10/04/2018 15/04/2018 0 Months 6 Days
15/04/2018 14/08/2018 4 Months 0 Days
15/04/2018 20/08/2018 4 Months 6 Days
29/02/2020 31/03/2020 1 Month 3 Days should consider Leap Years and Day Light savings period as well
To see attachments, please log in.
Java and Activities
User Experience

Posted: 7 years ago
Updated: 7 years ago
Posted: 13 Jun 2017 1:18 EDT
Updated: 13 Jun 2017 1:19 EDT
Bhanu Prakash Reddy Anugu (BhanuPrakashAnugu)
TMHCC
Senior Pega Engineer
TMHCC
GB

Hi Joestalin,

There is no specific inbuilt function available in Pega, write your own function and use that as per the requirement.

Thanks & Regards,

Bhanu Prakash.

To see attachments, please log in.
Posted: 7 years ago
Posted: 22 Jun 2017 19:54 EDT
Stalin Arockiam (Stalin Arockiam)
Bank of New Zealand
Senior System Architect
Bank of New Zealand
IN

Thanks Bhanu, I tired but still i am facing issues with few scenarios (Daylight savings & when days are within Feb month ).I will update you all once I get the final solution.

 

 

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