Filtering between dates

[BillyL14]

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

[BillyL14]

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

[atcodedog05 · Accepted solution]

Hi @BillyL14 ,

You use filter tool like below:

Hope this helps 

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

[mceleavey · Accepted solution]

Hi @BillyL14 ,

Configure your filter tool as below:

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.

[BillyL14]

@mceleavey @atcodedog05  thanks!

[atcodedog05]

Happy to help 

Cheers and happy analyzing 

[hemant86]

Hi mceleavey...

I'm trying to update the dates through user input via calendar tool. Its not updating the selected dates for me I have attached my workflow. Any help will be greatly appreciated.

[mceleavey]

Hi @hemant86 ,

You hadn't configured your action tools:

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.

[Arunkumar25]

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