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

[tsweat (tom)]

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!!!

[tsweat (tom)]

renew date.xlsx (8.3 KB)

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

[arivu96 (Arivazhagan A)]

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")

Regards,
Arivu

[tsweat (tom)]

You are the hero! This is working.

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