cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Compare full date in Excel

Hi,

 

Please, I need compare full date in Excel with the actual full date (Date + Hour), but when I try, don't work, because the date in Excel is a number, and the expression addDays('1899-12-30',int(item()['Date']),'yyyy-MM-dd') doesn't work in this case, because I'm using hour too, not only the date.

 

For example:

Date in Excel: 10/11/2019 14:00. I need to know if it is before or after now.

 

Thank you!

 

Best regards,

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: Compare full date in Excel

@Haufe 

Here are two possible solution to your issue:

Solution 1

Solution 2

 

 

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

Scott
Highlighted
Helper II
Helper II

Re: Compare full date in Excel

Hi  ,

 

Thank for the asnwer but doesn't work, because I have hours also in the date, then when I will convert to int shows an error, because the number that come of the Excel is for example 4365.219139, so can't to convert to int because is a float. 

 

Best regards,

 

Highlighted
Community Support
Community Support

Re: Compare full date in Excel

Hi @Haufe ,

 

If the number that come of the Excel is a float type data, you could consider converting the current time to a float type data, and compare the float type data of current time with the float type data of excel time.

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper II
Helper II

Re: Compare full date in Excel

Hi  

 

 

 

Highlighted
Helper II
Helper II

Re: Compare full date in Excel

Hi,

 

Could someone help me with the question?

 

Thank you 🙂 

 

Best regards,

 

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
Users online (6,042)