alert before one months date of expiry

Question

hello i want to show list of customer expiry licence before one month of date expire in c# application

Iftikar Hussain · Answer

Hi You can try like this get data by using the below query and bind it to your gridview SELECT *FROM YourTable WHERE (CASE WHEN DATEDIFF(MONTH GETDATE() LicenceExpiryDate) >= 1 AND DATEPART(DAY LicenceExpiryDate) >= DATEPART(DAY GETDATE()) THEN DATEDIFF(MONTH GETDATE() LicenceExpiryDate) WHEN DATEDIFF(MONTH GETDATE() LicenceExpiryDate) >=1 AND DATEPART(DAY LicenceExpiryDate) END)>0 Regards Iftikar