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.
I'm sorry, I didn't see AND
No problem! Hopefully it works now then!
Alexnajm,
I am trying to get basically a date range that automatically provides appointments for the next 20 days. This is what I have thanks to your help:
[Next Cardio Appt]<=DateTimeAdd(DateTimeNow(), 20,'days') AND [Next Cardio Appt]>DateTimeToday()
But the result are still not just the next 20 days (attached). I'm sure that I continue to do something dumb!
I'm sorry I was looking at the wrong column! This is now PERFECT!
Thank you. Thank you. THANK YOU!
Happy to help!