DateTimeDiff giving incorrect value for "months"

Hi ,

Is there a issue with the DateTimeDiff function. Its giving me incorrect values on multiple scenarios and correct on some. Please see the screenshot below of my result window. And this is the function I'm using DateTimeDiff([DOL],[DOJ],"month")

Date Time

Accepted answers

That did the job for me ....Thanks @atcodedog05

All comments

Here is an explanation for the output.

1st row difference is 5 months 28 days it considers only the month hence showing 5 months.

2nd row difference is 6 months hence showing 6 months.

Hope this helps : )

Here is what you can do to get the required output absolute months difference.

Workflow:

Hope this helps : )

Thanks @atcodedog05 ...for the clarification!

Quick Links

Tags

This months top contributors

Hollingsworth 335