Hi.
I have a SQL data extraction and I need to filter the table by a field called "StartDate".
I tried:
and the same adding ''
but none of those are working, getting the following error (If I remove the last filter everything works fine). How should I set the operator less than the Date field?
{
"error": {
"code": 502,
"source": "firstrelease-001.azure-apim.net",
"clientRequestId": "1821bc4e-2b9e-43bf-b1c1-ddcf8bc916b3",
"message": "The response is not in a JSON format."
}
}
Hi @ezequiel
What's your StartDate Format? Most likely you need to format your utcnow in that format.
Check this post https://powerusers.microsoft.com/t5/General-Flow-Discussion/SQL-OData-UTC-Now/td-p/71005
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi,
This is the format of the field....any suggestion? Thanks!
Ezequiel
Hi @ezequiel
Could you please post a screenshot of the startdate how it is stored in sql. If you don't have direct access then post a runtime history of sql data. This will show how the data is stored.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks for your reply. Try to use this expression and compare formatDateTime(utcnow(), 'yyyy-MM-dd')
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogUser | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |