How to write while condition to check cell is empty and date in other cell is less than or equal to today date

Learn
1

i want to write the condition in while loop to check the ‘Status’ column is empty or null and date in the Date column is equals to or less than today’s date. i want to write this condition in while loop how to write that

2

@bpt.teja1996

Do you want to check for any particular cell value or want to check whole Column values ?

If you want to check for multiple cells then use ForEach Row Activity instead of While loop Activity.

Try this:

           ForEach row in inputDT
                     IF String.IsNulrEmpty(row("Status").Tostring AND row("Date").Tostring("dd/MM/yyyy") <= Now.ToString("dd/MM/yyyy")
1 Like
3

hai @lakshman i took the for each and i want to check those two conditions so in the for each i took while condition

4

@lakshman can you please check the if condition i was getting error

Screenshot (21)
Screenshot (21)1920×1080 196 KB

5

@bpt.teja1996

Sorry. It’s typo error. It should be like this.

                   String.IsNulrEmpty(row("Status").Tostring)