Using Filter Query Between Two Dates

[koneill2020]

All, 

I am trying to run a Get Items action using a Filter query to obtain results between my StartDate and EndDate for 7 days out as such:

StartDate ge (utcnow()+7),'dd-MM-yyyy') and Enddate lt (utcnow()),'dd-MM-yyyy'))

this is giving me the following error:

{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The expression \"StartDate ge (utcnow()+7),'dd-MM-yyyy') and Enddate lt (utcnow()),'dd-MM-yyyy'))\" is not valid."}}}

so not being a Filter Query guru - what is the correct syntax for obtaining what I am trying to do.

[GeorgiosG]

Hi @koneill2020 ,

try using addDays(utcNow(),7) instead of your brackets.

https://powerusers.microsoft.com/t5/Building-Flows/Sharepoint-Get-Items-ODATA-Filter-with-adddays/td...

[v-bofeng-msft · Accepted solution]

Hi @koneill2020  ,

Please try:

StartDate gt '@{addDays(utcNow(),7,'yyyy-MM-ddTHH:mm:ssZ')}' and Enddate lt '@{utcNow('yyyy-MM-ddTHH:mm:ssZ')}' 

Best Regards,

Bof