Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesHighlighted 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 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.