Less than Date

[ezequiel]

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."
}
}

[abm]

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

[ezequiel]

Hi,

This is the format of the field....any suggestion? Thanks!

Ezequiel

[abm]

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.

[ezequiel]

@abmhere you go!

[abm]

Thanks for your reply. Try to use this expression and compare formatDateTime(utcnow(), 'yyyy-MM-dd')