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.
Solved! Go to 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
Hi @koneill2020 ,
try using addDays(utcNow(),7) instead of your brackets.
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