on 02-25-2011 8:37 AM
Hi all,
I Need Alert for the Customer via Date of Birth?
Thanks
Anish
Hi Anish....
Please try this....
SELECT T0.[CardCode], T0.[Name], T0.[Position], T0.[Address], T0.[BirthDate] FROM OCPR T0
WHERE T0.[BirthDate] =getdate()
Save this query and store this as in Alert management and set the time when exactly want alert on customer's Birthday.
In Above query when System Date equals to customer's Birth date it will fire an alert at your defined time.....
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.