How to add 'less than or equal to' in a filter query ?

(0) Share

Report

Posted on by Githendra23

150

Hi everyone,

I would like some assistance about my problem.

I'm trying to compare today's date with a date in a column of an item. I've added a "Get item" action to do so but I'm not sure how to add "less than or equal".

How do I do that ?

Thanks in advance,

Categories:

General topics

All responses (4)

Answers (1)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please try to change the type of field to Date and time(not include time) in SP column internal name.
Try to get SP column internal name. Run without configuring any filters in Get items and check the body of the Get items action to get the display name of the date field and configure the query as below:

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Githendra23 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ankesh_49 ,

Thanks for the quick reply,

I already know the internal names of the columns. I would like to do "less than or equal to" utcNow() insteal of "less than"
Verified answer

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

For instance if you want to Filter query date range:
Created ge '2022-12-24' and Created le '2022-12-31'

Match documents where the Rating field is between 3 and 5, inclusive:
Rating ge 3 and Rating le 5

Therefore, instead of le gt, use ge le
Githendra23 150 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for the answer !