[2005] Anything less than a value?

[TCarter]

As per the code:

            Using command As New MySql.Data.MySqlClient.MySqlCommand("select NextDue from Company_ID where NextDue = '" & todaysdate & "'", connection)

Where todaysdate is, I actually want it to look for anything less than that. Any ideas?

I was trying "& < todaysdate &", but it needs something before it to reference off of.

In a sense, the program is looking for dates that are were due before today's date.