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-...

[Qiu]

@DC21 
A sampel