Who can save me? If beginrenew date = today's date, then do

email from spreadsheet.xaml (28.0 KB)

I have created an automation that gets information from an Excel sheet. If the date in the spreadsheet equals today’s date, then the automation fills a pdf and sends an email with the pdf attached. I canNOT get the correct formula in the IF statement to compare the date from the spreadsheet to today’s date!!! I have attached my xaml file. Will upload the spreadsheet next. THANK YOU TO ANYONE WHO CAN SAVE ME!!!

renew date.xlsx (8.3 KB)

This is an the data (date) from the spreadsheet that I need to compare to today’s date.

Hi @tsweat,
In the for loop you can use the below condition

Convert.Todatetime(row("Begin Renew or Replace")).ToString("dd/MM/yyyy")= datetime.now.ToString("dd/MM/yyyy")


1 Like

You are the hero! This is working.

Thank you so much. I hope I can help you some day. Thank you!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.