Date time diff not giving desired result

[Isha_Gupta]

Hey,

I have a date column in date data type which needs to be filtered out for the values which are older then 6 months

I have used DateTimeDiff(DateTimeNow(),[Date],"months") > 6 in filter.

But I am getting values like 2022-09-30, 2022-10-14 which are clearly less then 6 months old.

Any solution would help...Thx

[binuacs]

@Isha_Gupta Try to change the formula like below

DateTimeDiff([Date],DateTimeNow(),'months')

[ShankerV]

Hi @Isha_Gupta 

Can you please share few screenshots of the filter tool.

As far when I replicated the same in my system, it is working accurately right.

Input was:

Output: I do not see 2022-10-14 in the output. Used same formula as yours.

Many thanks

Shanker V

[Isha_Gupta]

Values like 2022-08-10 should have come out of True as it is more then 6 months for that value but it is still coming out of false.

Many other such values are failing the filter and either going in true or false when it should have been the opposite.

[binuacs · Accepted solution]

@Isha_Guptayour formula is checking for > 6 months not >= 6 months, if you are looking to include 6 months updated your formula to >= 6