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
Your conditions are:
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)