Highlighted in this post: Solved: DateDiff question - Alteryx Community The DateDiff function under certain conditions does not work as you would expect and I suspect most people would not notice the inaccuracy.
Here is the formula for the Results Column below:
DateTimeDiff("2022-11-30",[Date],"months")
Date |
Expected |
Result |
2022-11-15 |
0 |
0 |
2022-10-31 |
1 |
0 |
2022-09-30 |
2 |
2 |
2022-08-31 |
3 |
2 |