I have an if activity, where I have two conditions. If the end date in my excel file is blank or has a value of 2099, T should be written in a cell. If the value is anything other than blank or 2099, F should be written in the cell.
When I execute the application
F is appearing in 2099 (It should be T)
T is appearing in blank cells (Correct)
F is appearing in cells other than blank or 2099 (Correct)
Could someone please help me fix my error so that T will also appear in cells with 2099?
Thank you,
String.IsNullOrEmpty(row(“End Date”).ToString) or row.item(“End Date”).ToString = “2099”
@MF.RPA
give a try on following just for analysis purpose:
(isNothing(row(“End Date”)) OrElse String.IsNullOrEmpty(row(“End Date”).ToString.Trim)) OrElse row.item(“End Date”).ToString.Contains(“2099”)