Compare full date in Excel

[Haufe]

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,

[ScottShearer]

@Haufe 

Here are two possible solution to your issue:

Solution 1

Solution 2

[Haufe]

Hi  ScottShearer,

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,

[v-alzhan-msft]

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.

[Haufe]

Hi  v-alzhan-msft,

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.

Best regards,

[Haufe]

Hi,

Could someone help me with the question?

Thank you 🙂 

Best regards,