How to make an sql statement when the were clause is a date?

[roncansan]

I'm using progress 91D and the odbc driver from OpenLink 3.2.
I want to make the following sql statement

select mb-num
from pro1.mb where logindate='30-NOV-08'

but it gives me an error

What is the correct way to make this statement
Thanks

 

[roncansan]

select mb-num
from pro1.mb where logindate='30-NOV-08'

will be like

select mb-num
from pro1.mb where logindate={ d 1980/5/19 }

 

[ERPgal]

or ...

and jh.duedate between to_date('10/28/2008') and to_date('11/19/2008')