Comparing dates from excel

Reem Outa 1 Reputation point
2021-06-29T12:22:15.273+00:00

Hello,

So I have a small problem with power automate. I have a flow that when a form is submitted it should check if the date put in the form less than 30 days from now, then it should send an email. However, I am having trouble with the date. The date on my excel sheet is in the format: dd.MM.yyyy and the date from utcnow - 30 is a lot longer because it includes the time as well and comes in a very long format. I need to compare the 2 dates and they need to be in the same format. Anyone had trouble with this or knows how this could be fixed I tried almost 10 techniques and none of them worked so far.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,162 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 8,991 Reputation points
    2021-06-29T13:00:18.963+00:00

    Hello @Reem Outa

    You would be better served on the dedicated Power Automate Community :)
    A quick search there => Is there an expression in Flow like =TODAY() in Excel that gives today's date as output?. OK, that's not exactly what you want but in the answer they talk about formatDateTime...

    (Am not a Power Automate/Power Flow user)

    0 comments