DateDiff inconsistency?

I ran into what looks like an inconsistency (or it’s too late in the day and I’m missing something obvious) in how DateDiff computes months.

Here’s my sample data:

As you can see, all 4 sets of dates have the same number of days between them, but different number of months. If I had to generalize from what I’m seeing, it’s working differently depending on whether the boundaries are at month beginning / end vs mid-month. Is this expected?

Hi @kolosy,

When you use month as period with the DateDiff function, QuickSight doesn’t take into account the day of the month. In your first row, that’s equivalent to counting the number of months between Dec 1 and Nov 1. If that’s not the result you expect, you can use day as your period and divide the result by 12.