cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Date Comparison Expression - What is wrong?

Hi,

 

I am trying to only get rows where date_entered is 10 mins or more older. I keep getting an invalid expression when i input this:

 

@less(formatDateTime(items('Apply_to_each')?['date_entered'],'dd-MM-yyyThh:mm'), addMinutes(utcnow('dd-MM-yyyThh:mm'),-10))
 
Any help would be greatly appreciated.
 
Many Thanks

POC
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Date Comparison Expression - What is wrong?

@ICEPOC :

 

Take a look at the comments below this blog post.  Specifically the comments regarding comparing two dates from Roy Gilboa.  I believe this will help.

 

 

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

Scott

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: Date Comparison Expression - What is wrong?

@ICEPOC :

 

Take a look at the comments below this blog post.  Specifically the comments regarding comparing two dates from Roy Gilboa.  I believe this will help.

 

 

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

Scott

View solution in original post

Highlighted
Regular Visitor

Re: Date Comparison Expression - What is wrong?

Hi @ScottShearer,


Thanks for the link.

 

Do you hapen to know if the 'ticks' work with addminute? Every example i see is always referencing the adddays expression.

 

Many Thanks

POC

Highlighted
Super User III
Super User III

Re: Date Comparison Expression - What is wrong?

@ICEPOC 

If you are using ticks, you'll need to convert minutes to ticks, add the ticks and then convert back.

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,034)