Filter data in specific timeranges

[Kk_larsen]

I have data with dates in this format: 2020-09-21 11:11:17 and I want to filter on dates that is between 2020-09-23 12:06:21 and 2020-09-23 09:07:21 is that possible? 

[jdunkerley79]

Yes a filter expression like:

[Time] >= "2020-09-23 12:06:21" AND [Time] <= "2020-09-23 09:07:21"

should do what you need

Making the assumpting the dates are in a [Time] column! 

[marcusblackhill]

Hey @Kk_larsen !

You can append your limits to you database and use a filter testing the data with your limits, that way you can do that filter based in your choice of limits.

Look the attached workflow.

Hope that help!

[atcodedog05 · Accepted solution]

Hi @Kk_larsen 

Once you have a datetime field

if you pull a filter after it and select datetime field it lets you make selection of date range. You can use a easy dropdown to set the limits.

Hope this helps 🙂

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

[atcodedog05]

Happy to help 🙂 @Kk_larsen 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂