I have a table that has these values:
From the data | Todate | Is complete
2018-11-01 | 2018-11-15 | one
2018-11-16 | 2018-11-30 | one
I need to verify if the is_Complete column is 1 from the first day of the month and from the 16th to the last day of the month, then process my queries, but if one of them is 0 I will not process it.
I'm not sure if CAST will work here.
If both is_Complete == 1, then
process queries ELSE & # 39; N / A & # 39;