cancel
Showing results for 
Search instead for 
Did you mean: 

Alert - Customer Date of Birth

Former Member
0 Kudos

Hi all,

I Need Alert for the Customer via Date of Birth?

Thanks

Anish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

kvbalakumar
Active Contributor
0 Kudos

Hi Anees,

Try this

SELECT T0.[CardCode], T0.[Name], T0.[Position], T0.[Address], T0.[BirthDate] FROM OCPR T0 
WHERE datediff(dd,T0.[BirthDate],getdate()) =0

Regards,

Bala

Former Member
0 Kudos

Hi Bala,

Thanks a lot, it was working fine.

Anish

Answers (0)