Unanswered

Power Automate filter query ODATA compare date

(0) Share

Report

Posted on by jpr23

i just want to compare 2 dates in a filter query Odata.

I want to compare the "modified" field with an another date time field "mydate" , but i cannot succed to find the right syntax !!

In the filter request i would like to write something like

Modified ge 'mydate'

but it doesn't work !

I've tried to convert by formatdatetime.. but no !!

Please help me in the syntax !

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@jpr23 when comparing dates it is always wise to use yyyy-MM-dd format. So my suggestion would be to add 2 compose actions, one for the modified date and one for mydate and format both with using a formatDateTime expression.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
jpr23 45 on at

Like (0)

Report

Of course but , it is in the Get Items action . So i have to indicate a filter query to filter the get Items.
The syntax must be similar to :
Modified gt .....myDateField

where
Modified is the standard field of the list
MyDate is my own date/time field to compare

I don't know if i have to convert the Modified date format also ?
I am stopped in the syntax !!!

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@jpr23 you don't HAVE to use a filter query, you just get the warning because using one can make the get items more efficient. The main thing to remember is that the date format of each side MUST be exactly the same and formatting it in yyyy-MM-dd is the best way to ensure this.

Rob
Los Gallardos

Was this reply helpful? Yes No
jpr23 45 on at

Like (0)

Report

Hi ,

this is the Get Items ( in french)
I just want to compare the "Modified" date field with my own date field...
But i don't know how !!!
Modified gt Mydate
or
Modified gt formatdatetime(mydate,'yyyy-MM-dd HH:mm' )
....
or other ?

Was this reply helpful? Yes No