cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
froojd92
New Member

Odata Filtering

Hi,

 

im trying to filter out based on a datetime column. ive tired with ge, gt, and even eq but no sucess, any ideas?

 

Background: i want to filter out all rows containing a datetime older than 60 days. 

 

Looking like this currently:

froojd92_0-1623168328679.png

 

Expression looks like this:

addDays(utcNow(),-60,'yyyy-MM-ddTHH:mm:ssZ')

 

1 REPLY 1
ScottShearer
Super User
Super User

@froojd92 

Take a look at this post as I believe it contains a solution to your issue.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,807)