DateTimeDiff giving incorrect value for "months"

[hemant86]

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")

[hemant86]

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")

[atcodedog05]

Hi @hemant86 

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 : )

[atcodedog05]

Hi @hemant86 

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

Workflow:

Hope this helps : )

[hemant86]

Thanks @atcodedog05 ...for the clarification!

[hemant86 · Accepted solution]

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

[atcodedog05]

Happy to help : ) @hemant86 

If my response helps please don't forget to mark my response as solution.

Cheers and have a nice day!