How to create Pupup Message according to the CLAIMDATE?

Question

Dear All I would have to implement the Claimdt Concepts for the purchase Order.According to the CLAIMDT Column i need to popup the message for the users. This Should popup before 2 or 1 month of the actual claim Date.. I have included the Data in excel ..I need query as well as i need popup coding. For Example : Purchasedt Claimdt 20/7/2013 20/7/2014

Iftikar Hussain · Answer

it will consider from current date only just modify like this SELECT *FROM YourTable WHERE (CASE WHEN DATEDIFF(MONTH GETDATE() Claimdt ) >= 2 AND DATEPART(DAY Claimdt ) >= DATEPART(DAY GETDATE()) THEN DATEDIFF(MONTH GETDATE() Claimdt ) WHEN DATEDIFF(MONTH GETDATE() Claimdt ) >=2 AND DATEPART(DAY Claimdt ) END) Regards Iftikar

Iftikar Hussain · Answer

yes just pass the client id in that query Regards Iftikar

Karthik Che · Answer

Dear Comrade  Is it Possible to show in client Page this Warranty Data Using this Query  one by One Using the Javascript. Thanks in advance - Ernesto Karthik

Karthik Che · Answer

Dear Friend  It selects the according to last two months dataits not Checking the Year for selection.

Iftikar Hussain · Answer

you can display list of records which claimdt will end in next 2 month in your sql query put condition like this SELECT *FROM YourTable WHERE (CASE WHEN DATEDIFF(MONTH GETDATE() Claimdt ) >= 2 AND DATEPART(DAY Claimdt ) >= DATEPART(DAY GETDATE()) THEN DATEDIFF(MONTH GETDATE() Claimdt ) WHEN DATEDIFF(MONTH GETDATE() Claimdt ) >=2 AND DATEPART(DAY Claimdt ) END)>0 Regards. Iftikar

Karthik Che · Answer

Dear Friend I want it for ASP.NET application.it is need for myHome Page is Enough.what are the Cliamdt are avilable those only.. Before 2 months or 1 months Thanking you

Iftikar Hussain · Answer

Hi Where exactly you want to display the popup alert? Are you looking for ASP.NET or Windows Application? Regards Iftikar