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?
You need a condition to also exclude anything older than today then - [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()
I think you want to flip the sign! Here's my quick example that works:
Well this didn't work. Better but not quite. Sigh
[Next Cardio Appt]<=DateTimeAdd(DateTimeToday(), 20,'days')
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()
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!
