DateTimeDifference with decimal Months.days

[jenniferte]

Hi,

Need some help to calculate the DateTimeDifference with decimal Months.days:

Example:

Date Start=2023-12-29

Date End=2024-03-12

Months.days= 2.12days

[Qiu · Accepted solution]

@jenniferte 
A quick sample as below.
First we calculate the difference for Month between dates, then add the dffrence of Month to the "Start Date" then calculate the difference between new Start Date and End Date.

[jenniferte]

Thank you so much Qui! 

[jenniferte]

Thank you Qui!

[Qiu]

@jenniferte 
Glad to help.