How too write if condition to check cell is empty or not and date in Date column is less than or equal to today date

Learn
1

i want to write the condition in IF 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 IF how to write that

2

Hey bpt.teja1996.

Your conditions are:

string.IsNullOrEmpty(row.item(“Status”).ToString)

and

datetime.ParseExact(row.item(“Date”).ToString,“MM/dd/yyyy”,system.Globalization.CultureInfo.InvariantCulture) <= DateTime.Now

Remember to change “MM/dd/yyyy” if your dates are in another format (e.g. if your dates are with days before months like 20/05/2019, then you substitute it with “dd/MM/yyyy”. I’ve attached the workflow.

Kind regards, Anders

Main.xaml (7.7 KB)

1 Like