on 05-24-2016 7:30 AM
How to fix alert for new item adding and update. Please help me
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Query for New Item Creation:
SELECT T0.[ItemCode], T0.[ItemName], T0.[CreateDate] FROM OITM T0 Where DateDiff(DD,T0.[CreateDate],GetDate())<1
SELECT T0.[ItemCode], T0.[ItemName], T0.[CreateDate] FROM OITM T0 Where
DateDiff(DD,T0.[CreateDate],GetDate())<1
Cheers
Thank you so much. Very helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.