Select Data between dates

Hi
I am wondering how can I select data between two dates (ie from 08/12/2004 to today?)

Name DateS
Bob 08/11/2004
Tom 08/12/2004
Bill 09/21/2004 <-- today

return

Tom 08/12/2004
Bill 09/21/2004

Thanks in advance for your help

select name, date from x where date >= '08/12/2004' and date <= sysdate;

select name, date from x where date between '08/12/2004' and sysdate;

the solution is correct. Just remember to convert your char string to date
select name, date from x where date between to_date('08/12/2004','mm/dd/yyyy') and sysdate

Santosh