Date range issue

[rhearns1]

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?

[rhearns1]

I'm sorry, I didn't see AND

[alexnajm]

No problem! Hopefully it works now then!

[rhearns1]

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!

[rhearns1]

I'm sorry I was looking at the wrong column!  This is now PERFECT!

Thank you.  Thank you.  THANK YOU!

[alexnajm]

Happy to help!