annual dates list help

Question

Hi All,

I have a table of important annual dates. I'd like to display them in a gridview with the date that's coming up to be on top row relative to today's date. For instance, if my birthday is the next thing coming up that should be at the top row of the gridview.

What's the best way to do this?

Thanks,

rod.

Answer 1

If you are looking for an SQL, something like SELECT * FROM YourDatesTable WHERE ImportantDate >= GETDATE ORDER BY ImportantDate DESC might work.