Count number of months between 2 dates

DC21

Hi

if I have a 

date 1= 15/10/2021

date 2= 29/01/2021

the no of months between the 2 dates rounded up is 9 months

how do I do this calculation in alteryx

Luke_C

Hi @DC21 

You can use a datetimediff function for this. The below thread has some good examples and possible solutions:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Endeavoring-to-extract-a-more-precise-number-of-months-and-days/td-p/444263