Excel date data match with current date

Help
8

Buddy @Sweetmisery
you were almost right. need to make small changes with if condition

Datetime.Parseexact(row(“Schedule”).ToString.Substring(0,10),“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”).Equals(now.ToString("dd/MM/yyyy)

then inside the send outlook mail activity you can include the row(“Message”).ToString
either to body or the subject buddy as you wish

Kindly try this and let know buddy whether it worked or not
Cheers…
if any error occured with string format conversion to datetime, kindly use a write line to check how the date text is getting printed in which format after obtaining from excel, based on that we can the format in the if condition buddy
@Sweetmisery

1 Like