Hi,
try following Query for upcoming Bdays
SELECT bDate AS
Birthday ,FLOOR(DATEDIFF(dd,bDate,GETDATE()) / 365.25) AS
Age_Now ,FLOOR(DATEDIFF(dd,bDate,GETDATE()+180) / 365.25) AS
Age_After_this_Week
FROM CustomerMaster WHERE 1 = (FLOOR(DATEDIFF(dd,bDate,GETDATE()+180) / 365.25))
- (FLOOR(DATEDIFF(dd,bDate,GETDATE()) / 365.25))
Note- 180 for get bdays from upcoming 6 months
thanks
best Luck
Happy Coding:)