Date ranges problem...

[andrea orlandini]

Hi,

I have to manage a table describing different legs for a travel.
I have a table with Leg_start_date and Leg_end_date date fields.
I have to determine which leg is the current leg for today.

I have tryed the following but didn't work....
("SELECT * FROM legs WHERE legstart <= date("Y/m/d") AND legend >= date("Y/m/d") ")

Any suggestion????

Thanks.
andrea