I am creating a query that will find the top 5 due dates for bills and order them from by the bill that is due the soonest. The query that I am using is :
SELECT TOP 5 Bill,DueDate FROM Expenses WHERE DATEVALUE(DueDate) >= DATE() ORDER BY DueDate ASC
I am displaying the results in a datagridview box in vb.net 2008. I guess what i want to be able to do, is query based on the month and day without the year playing a factor in it.