Skip to Content
0

Alerts for Open GRPO more than 30 days from posting date

Mar 09, 2017 at 01:32 AM

99

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Nagarajan K Mar 09, 2017 at 02:06 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0