Date Time Excel Filter Help
I have an excel file I would like to filter for a specific date time of 1/16/2020 12:00:00 AM. When I enter that as my filter criteria into the action, and then run it, I do not get the filtered data set I am expecting, even though the data is displayed in that exact way. I tried converting the file to a table to see if there is a formatting issue, and it looks like it is formatting the date to be displayed as 2020-01-16T00:00:00Z when the filter excel file step is running causing the filtered data set to be empty. How can I accommodate the current way the data is displayed for the filter to work and not have to have a workaround?