Question

4
Replies
1269
Views
STALIN A Member since 2011 3 posts
Monarch Info Tech Services Ltd
Posted: June 12, 2017
Last activity: June 22, 2017
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:

StartDateEndDateExpected ResultComments
15/04/201815/04/20180 Months 1 DayCount starts from Startdate as 1 day
10/04/201815/04/20180 Months 6 Days
15/04/201814/08/20184 Months 0 Days
15/04/201820/08/20184 Months 6 Days
29/02/202031/03/20201 Month 3 Daysshould consider Leap Years and Day Light savings period as well
Data Integration Java and Activities User Interface
Moderation Team has archived post
Share this page LinkedIn