|
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
|