Using Flow Designer to Compare Dates

[Ben124]

Hello, All!  I'm trying to use the Flow Designer to take the date from a specific field on a form and see if that date is tomorrow.  If it's not, I want it to check once every day until that date is tomorrow.  However, it just keeps checking and never finds that it's the day before (even when it is).  Any thoughts on how better to do this?  Thank you!

P.S. - I've also tried a condition of Planning Date relative before 1 day from now ... no help there either.

[Gabor Kiss]

Hello,

I just tested and "on Tomorrow" condition works correctly with the Look Up Records action (I tested on Rome version patch 7a). And in general, I see nothing wrong with your flow. However, I tested using a datetime field. Is the Planning Date field in your example date or datetime?

Thanks,

Gabor

[Ben124]

Does this answer your question?

[Ben124]

It was just a date field.  I have another that is datetime so I moved the data to that, adjust the flow to point to the new datetime field, but it still won't find it.  It just tries over and over again but never recognizes it....

[OlaN · Accepted solution]

Hi,

Not sure if it applies to this question, but I've built a small tool to help with date/time comparison in Flow designer.

Use it if you like, it's available on Share, or direct download from my community post.