Working with dates and the filter tool

[SVIGGIANO]

I have two fields that describe the date and time of my event - RunStartDate and RunStartTime.  I have a database of many thousands of these events and I want to query that database every day for the events that occurred from 7 AM the previous day until 7 AM on the current day.  I have not worked with dates much in Alteryx so I am asking if there is an effective way to do this.  Thank you all very much.

[mbarone · Accepted solution]

As long as your fields are in date/time format, you can make use of all the DateTime functions:  https://help.alteryx.com/current/designer/datetime-functions

[StephV]

Hi @SVIGGIANO, 

Thank you for your question to the Community!

I moved your post to the Designer Discussions forum there you can ask anything technical about Designer and  there is the best place to get help from the Community. This article "Q&A: Where Do I Post My Questions?" should also help you out. 

If this @mbarone's post helped you please mark it as solution. Thank you!

Let us know if you need any help! 

Cheers,