How use OData $filter query dynamic date

Question

I'm trying to use Microsoft Flow to fetch all my calendar events for the past two weeks, and do this every two weeks. The problem is that the "get all events" outlook action only accepts an ODATA $filter query and it's not clear how to filter it dinamically, something like:

$filter=Start ge Today()-14

Is that even possible? Thanks!

Possible duplicate of [How to filter oData call using dynamic date?](http://stackoverflow.com/questions/25471104/how-to-filter-odata-call-using-dynamic-date) — sgryzko, Apr 11 '17 at 16:57

score 0 · Answer 1 · edited Jun 24 '17 at 06:29

0

Try to build IF statement with the following condition

StartDate ge @{adddays(utcnow(‘yyyy-MM-dd’), -14, ‘yyyy-MM-dd’)}

Please find more info at the MS docs.

edited Jun 24 '17 at 06:29

Nathan Tuggy

2,237
27
30
38

answered Jun 24 '17 at 05:57

vmoskalenko

46
3

How use OData $filter query dynamic date

1 Answers1