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!
Solved! Go to Solution.
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
Thank you! I feel embarrassed I did not consider that - but I appreciate you nonetheless!