web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ODATA filter Query on ...
Power Automate
Unanswered

ODATA filter Query on date

(0) ShareShare
ReportReport
Posted on by

Hi All,

if i want to filter date using ODATA query

i want to filter the dates that are 2 days before today, for example i wat to filter the dates starting from 6th of December and below 

what i should choose (equal to , or less than, or greater than), and what will be the expression giving that the date format in the SP is MM/DD/YYYY 

 

MostafaGamal_0-1670505132577.png

 

 

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    I will recommend that you use the dateDifference function and go with the universal 'yyyy-MM-dd' format.

     

  • MostafaGamal Profile Picture
    on at

    thanks for your response, can you please explain more

    i dont have that much of experience in power automate 

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    On second thoughts, you could try the ticks function. tick is a 100-nanosecond interval.

     

    sub(ticks(formatDateTime('2022-10-12','yyyy-MM-dd')),ticks(formatDateTime('2022-11-12','yyyy-MM-dd')))
     
    It will return a positive or negative number based on which date is greater.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard