How to create Pupup Message according to the CLAIMDATE?

Karthik K

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted 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 ) < DATEPART(DAY, GETDATE()) THEN DATEDIFF(MONTH, GETDATE(), Claimdt ) - 1
END)<=2

Regards,
Iftikar
Iftikar Hussain13y ago
yes, just pass the client id in that query

Regards,
Iftikar
Karthik K13y ago
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 K13y ago
Dear Friend ,

It selects the according to last two months data,its not Checking the Year for selection.
Iftikar Hussain13y ago
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 ) < DATEPART(DAY, GETDATE()) THEN DATEDIFF(MONTH, GETDATE(), Claimdt ) - 1
END)>0

Regards.
Iftikar
Karthik K13y ago
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 Hussain13y ago
Hi,
Where exactly you want to display the popup alert? Are you looking for ASP.NET or Windows Application?

Regards,
Iftikar