Comparing Excel column data of date with system date

@nibir08

Welcome to UiPath Community

1.use Excel Application scope in it use Read Range read the excel and store it in a Data table Dt1.
2.use assign and get system date=datetime.now.toString(“dd/MM/yyyy”)
3.parse the system date
DateTime.ParseExact(systemdate,“dd/MM/yyyy”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)
4.use For each row
5.now we need to parse the date column,use Assign
DateTime.ParseExact(row(“column name”).ToString(),“MM/dd/yyyy hh:mm:ss”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)
6.now use IF condition

Regards,
A Manohar

3 Likes