Working with dates and the filter tool

Question

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 Answer

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