SELECT *, IIF(edate BETWEEN DATE() AND GOMONTH(DATE(),+1),1,0) AS limit,; GOMONTH(DATE(),+1) - edate As Daysleft FROM Master WHERE edate >=DATE()