OData Filter OR operator not working with dates

[BenMunk]

Am I missing something really simple?

Inside a flow, inside of Sharepoint Get Items action

This returns multiple items

DateComplete gt '@{outputs('Compose')}'

This returns multiple items

StaffChangeToCompleteDate gt '@{outputs('Compose')}'

This returns nothing

DateComplete gt '@{outputs('Compose')}' or StaffChangeToCompleteDate gt '@{outputs('Compose')}'

For context - here's where I'm using it.

 

[SudeepGhatakNZ]

@BenMunk ,

Try comparing the dates in the same format using the formatDatetime function. The format you should use is yyyy-MM-dd.

Like:

DateComplete gt formatDateTime('@{outputs('Compose')}','yyyy-MM-dd')

[BenMunk]

Thanks for you suggestion, but I seem to be getting a syntax error with that "The query is not valid."

[BenMunk]

@SudeepGhatakNZ   I tried formatDateTime on the Compose action.  Syntax worked fine, but still same problem with the filter - each clause fine by itself, as soon as combine the clauses with the "or" operator, I get no results.

[SudeepGhatakNZ]

Can you upload a screenshot?

[BenMunk]

First screenshot shows setup and output with "or" operator - no results.  Second screenshot shows same thing without the "or" statement - multiple results.

 

 

 

[BenMunk]

Its possible that its a bug.  

It seems I can run 

• Date type column filter by itself (eg. 'date' gt 'yyyy-MM-dd') - works fine
• OR operator with 2 Non-date types (eg. 'id' eq 'x' or 'status' eq 'y') - works fine 
• OR operator with mix of Non-date type and Date type (eg. 'id' eq 'x' or 'date' gt 'yyyy-MM-dd') - disregards the date filter - only returns (id = x)
• OR operator with 2 Date types (eg. 'dateA' gt 'yyyy-MM-dd' or 'dateB' gt 'yyyy-MM-dd' ) - returns nothing.

[SudeepGhatakNZ]

Interesting! I will have to try that out. I use Or all the time. Can't find an example where two dates are involved.

[BenMunk]

Would be interested to hear if its happening for you.  In the end I had to use non-date columns to achieve my needs.  If it is a bug hopefully its rectified soon.