Alerts for Open GRPO more than 30 days from posting date

[former_member236650]

Hi SDK Experts!

I need help with the creation of an alert query for open GRPO's more than 30 days from the posting date.

Thank you!

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this query,

SELECT T0.Docentry,T0.[DocNum], T0.[CardName], T0.[DocDate], T0.[NumAtCard] FROM OPDN T0 WHERE Datediff(day,T0.[DocDate] ,Getdate()) = 30

[former_member236650 · Accepted solution]

Hi Mr. Nagarajan K,

The query works well, thank you!

I just changed the Datediff(day,T0.[DocDate] ,Getdate()) = 30 to Datediff(day,T0.[DocDate] ,Getdate()) > 30