Answered

Email confimation based off tomorrows date from excel

(0) Share

Report

Posted on by joshspeg

Looking for a bit of help. I was able to make the flow work with the conditions of utcNow('yyyy-MM-dd') is equal to the date in my excel document. But I am trying to have this send the day prior to the scheduled date to confirm the inspection. I tried

formatDateTime(addDays(utcNow(),1),'yyyy-mm-dd') is equal to date in the excel document but that didn't work.

Screenshot below. Thanks for your help.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
Hi!

Your excel column is of type text not date, right? If so, I would try with

formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')

Double M with capital letters

Hope this helps

Was this reply helpful? Yes No
Verified answer

joshspeg 13 on at

Like (0)

Report
Copy link

Link copied!

I can't believe thats all it was.

Thank you for the help.

Josh

Was this reply helpful? Yes No
joshspeg 13 on at

Like (0)

Report
Copy link

Link copied!

To be clear is was making the mm capital MM. I had the text not date correct.

Was this reply helpful? Yes No