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.
Date in Excel: 10/11/2019 14:00. I need to know if it is before or after now.
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.
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.
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.
Thank you for the answer, but I have tried to convert the current time to float, but does not work, could you show me how i can to do this.
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.