Hey Pradeep,

Your query is good and it will work nice except in one condition,

Think that today is 27 december and I am showing birthdays in next week and i have few records like 29 december , 1 january, 28 december and 2 january in database.

So in that case the result should be

28 december
29 december
1 january
2 january

But your query will show the result
1 january
2 january
28 december
29 december

Thanks ,
Khwab Sheth