I am trying to filter 1,544 results for the next 2 weeks. However the filter doesn't produce the correct results. What am I doing incorrectly?
Solved! Go to Solution.
does this come after the previous one?
Please check the attachment - technically doesn't matter though.
I do also recommend being more thankful - "well this didn't work" elicits a negative response generally on the Community.
I'm sorry. Yes, you have been very helpful. I was just sad that it wasn't an instant fix.
Sounds like it's fixed now then, so if that's the case please make sure to accept the response that worked best as a solution. Thank you!
Okay, I have no clue what is wrong now.
[Next Cardio Appt]<=DateTimeAdd(DateTimeNow(), 20,'days')-[Next Cardio Appt]<DateTimeToday()
Why did you change the AND in my most recent attachment to a subtraction? Also it looks like you flipped the "great than" to "less than"
This is the full statement in that attachment: [Next Cardio Appt]<=DateTimeAdd(DateTimeToday(),14,'days') AND [Next Cardio Appt]>DateTimeToday()