on 2016 May 24 7:30 AM
How to fix alert for new item adding and update. Please help me
Query for New Item Creation:
SELECT T0.[ItemCode], T0.[ItemName], T0.[CreateDate] FROM OITM T0 Where
DateDiff(DD,T0.[CreateDate],GetDate())<1
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.