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!
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
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