I have a table that have these values:
From data | Todate | is_Complete 2018-11-01 | 2018-11-15 | True 2018-11-16 | 2018-11-30 | True
We are executing data every 1st day of the month. So assuming that It's already 1st day of december. I need to check if is_Complete column is True from first day of the previous month and 16th up to last day of the previous month then process my queries but if one of those is False I will not process it.
I am not sure if CAST will work here.
IF both is_Complete == True, then
process queries ELSE 'N/A'