Figuring out how to query date/time in the filter tool

Question

Hi,

I am attempting to use a simple date/time query to filter my data into 'records before 10:31:00' and 'records after 10:31:00'.  I am using this syntax in the Data Filter tool: ToDate([DateTime_Out]) < "2021-11-02 10:30:00".  I just want to know how to add in the time part of a date/time query.  I attached the spreadsheet, the workflow and an image.  I realize there are other ways to do this, however, I just want to know the syntax to make this exact workflow functional.  All help is appreciated!

Alteryx_Date_Time_Question.xlsx

Date_Time_Filter.yxmd

Chantelb · Accepted Answer

Hi @GIS_User01

Your workflow is almost already there, you just need to remove the ToDate(). DateTime_Out is already in DateTime format and if you needed to convert to DateTime rather than Date you should use ToDateTime().

Hope this helps!

Cheers,

Chantel