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! Go to 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)
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!
User | Count |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |