Need help to check if the date equel yesterday date

[Mohamed_Abbas (Mohamed)]

Dear All
i Need your help to check if the date equel yesterday date or not
i used if condition but it’s not working as i want and if not equel i want to take sheet name from row 0 and send by email please check snap Xaml
thanks all for support

[nimin (nimzz)]

Hi @Mohamed_Abbas,

After reading the excel to a datatable, Inside the for each row loop, Please use this condition to check whether the date in ‘column J’ is equal to yesterday date.
convert.ToDateTime(row(9)).ToString("MM:dd:yyyy") = now.AddDays(-1).ToString("MM:dd:yyyy")

Warm regards,
Nimin