Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filtering between dates

BillyL14
8 - Asteroid

Hi

I am trying to filter between dates and have been looking around the community trying to find a solution but I haven't been able to find so far, I imagine it is something fairly simple. I tried using the custom filter but it is not giving me what I want.

 

Please see my sample. How could I for example filter all dates between 5th of March 2020 and 6th of July?

 

Thanks

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @BillyL14 ,

 

You use filter tool like below:

atcodedog05_0-1602078549499.png

atcodedog05_1-1602078561436.png

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

mceleavey
17 - Castor
17 - Castor

Hi @BillyL14 ,

 

Configure your filter tool as below:

 

mceleavey_0-1602078622613.png

This will allow you to select a range of dates. Ensure the field is in a date format before entering the filter.

 

Hope this helps.

 

M.



Bulien

BillyL14
8 - Asteroid
atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂

 

Cheers and happy analyzing 😀

hemant86
11 - Bolide

Hi 

 

 

mceleavey
17 - Castor
17 - Castor

Hi @hemant86 ,

 

You hadn't configured your action tools:

 

mceleavey_0-1623831959988.png

 

mceleavey_1-1623831976703.png

 

mceleavey_2-1623831991592.png

 

I've resolved this and added the browse tool to render at the end of the run, so you can see the results. You can toggle this in your interface designer.

 

Hope this helps,

 

M.

 

 

 

 



Bulien

Arunkumar25
5 - Atom

Hi, I try to use the "filter" function. my requirement is to filter the date approval from yesterday to today(dynamic value) .  this is a custom formal which I tried "[Date Approved] = DateTimeToday() AND [Date Approved]= ToDate(DateTimeAdd(DateTimeToday(), -1, "days"))".

 

For example, today is 27 March 2023, and yesterday is 26 March 2023. i need a date from 26 to 27 this value should be in dynamic value.

 

the above formula doesn't work if tried separately today or yesterday date is working. 

 

 

 

Could you please advise me 

Labels