Weird result from working date formula

Here is my code 

(([Annual Review Date] > (TODAY() - 30)))

But it is returning true for these dates 

10/15/2022

10/4/2023

5/31/2023

What I am looking for is return true if it is 30 days within the date contained in [Annual Review Date] return True

I dont understand why the dates that are in 2023 are returning true, any ideas?

 

Solved Solved
0 3 102
1 ACCEPTED SOLUTION

TODAY() - 30 is thirty days in the past, and every date after that, including all future dates, are greater than that date.

Maybe what you mean is:

[Annual Review Date] < (TODAY() + 30)

View solution in original post

3 REPLIES 3

TODAY() - 30 is thirty days in the past, and every date after that, including all future dates, are greater than that date.

Maybe what you mean is:

[Annual Review Date] < (TODAY() + 30)

I understand that now. What I am trying to do is return the names of people that the [Annual Review date] is between today() and 30 days in the future. How could I code that?

I found the solution in another post. Thank for your help!

Top Labels in this Space