Question

4
Replies
1476
Views
Stalin Arockiam (STALIN A)
Monarch Info Tech Services Ltd
Technical Architect
Monarch Info Tech Services Ltd
IN
STALIN A Member since 2011 3 posts
Monarch Info Tech Services Ltd
Posted: June 12, 2017
Last activity: June 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
Data Integration Java and Activities User Experience
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.