Dynamics Community Forum Thread Details

Get Rows add date format in filter query in flow

i am trying to retrieve data from oracle. i added filter query with date field. i am getting an error. could you please advice me how i can format database date field

i used this filter query.

modified_date ge formatDateTime(variables('last_sync_Date'),'yyyy-MM-ddThh:mm:ssZ') (refer to the image1 below) and getting this error.

The DateTimeOffset text '2019-04-24T04:00:38Z\n\n\n\n\n' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range. inner exception: The DateTimeOffset text '2019-04-24T04:00:38Z\n\n\n\n\n' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range.\r\n inner exception: The time zone information is missing on the DateTimeOffset value '2019-04-24T04:00:38Z\n\n\n\n\n'. A DateTimeOffset value must contain the time zone information."},"source":"oracle-cc.azconn-cc.p.azurewebsites.net"}}

Please advise me how to add filter query to compare two date fields.

Modified date value is coming as : ": "2019-05-23T00:00:00Z",