[GENERAL] date expressions

[surfer girl]

I checked the manual on this but couldn't find a clear answer:

I've got two dates in a database, a start date and and end date, which are type 
"date." I want to compare these dates to today's date in the SQL statement, something 
along the lines of "startdate < date < enddate". Can this be done in the SQL select 
statement?

Thanks in advance


_____________________________________________________________
Get It Gear --> http://www.getitgear.com