topic Re: Date range issue in Alteryx Designer Desktop Discussions

Date range issue

rhearns1 — Wed, 20 Dec 2023 12:43:12 GMT

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?

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 13:12:30 GMT

I think you want to flip the sign! Here's my quick example that works:

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 13:57:05 GMT

Well this didn't work. Better but not quite. Sigh

[Next Cardio Appt]<=DateTimeAdd(DateTimeToday(), 20,'days')

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 14:03:01 GMT

You need a condition to also exclude anything older than today then - [Next Cardio Appt]>DateTimeToday()

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 14:02:44 GMT

does this come after the previous one?

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 14:04:48 GMT

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.

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 14:07:52 GMT

I'm sorry. Yes, you have been very helpful. I was just sad that it wasn't an instant fix.

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 14:11:32 GMT

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!

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 14:13:19 GMT

Okay, I have no clue what is wrong now.

[Next Cardio Appt]<=DateTimeAdd(DateTimeNow(), 20,'days')-[Next Cardio Appt]<DateTimeToday()

Filter (45) Parse Error at char(58): Formula: invalid type in subtraction operator

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 14:16:18 GMT

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()

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 14:28:16 GMT

I'm sorry, I didn't see AND

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 14:29:09 GMT

No problem! Hopefully it works now then!

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 14:36:28 GMT

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!

Re: Date range issue

rhearns1 — Wed, 20 Dec 2023 14:39:15 GMT

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

Thank you. Thank you. THANK YOU!

Re: Date range issue

alexnajm — Wed, 20 Dec 2023 14:47:14 GMT

Happy to help!