I am trying to query an SQL table that contains a date field. I tried to write that into a Sharepoint list date field, but it said it was an incorrect format. Here is a sample record in the SQL table:
Ultimatly I want to just find records in the SQL table that are within the last 3 days. I have a compose step that subtracts 3 days from utcNow, that appears to be working correctly. the output is 2024-08-04T00:00:00.0000000Z
When I try an ODATA query to limit the number of items returned ( insdte gt 2024-08-04T12:00:00Z ) I do not receive any data. I do know that there are current dates in the data set.
I have tried a number of other ODATA filters - insdte gt '@{addDays(utcNow(),-3)}' for example, but I never get any data returned. If I remove the filter and jsut ask for 10 records, I get the correct info returned.
What am I doing wrong?
