Date Month Difference Issue

DelData

hi there,

I am trying to get the month difference in the Date column but when i use DateTimeDiff i get Month Count for 01/08/2024 as 3 when all August Dates should be 2......

What i want is 

Current Month       : Month Count = 1

Current Month -1   : Month Count = 2

Current Month -2   : Month Count = 3

Current Month -3   : Month Count = 4

Current Month -4   : Month Count = 5

etc....

Green Wanted...Red is what i get

Date Wanted.yxzp

Date Wanted.yxmd

DataNath

Hey @DelData, as you were adding a +1 to compensate, this was causing the issue I believe. If you set both dates (today & the dates in question) to the first of the month in order to get a true month difference then that looks to solve the issue - I've checked the 3 you highlighted in particular:

DateTimeDiff(
DateTimeFirstOfMonth(),
DateTimeTrim([Date],'firstofmonth'),
'month')