Can anybody tell me why this does not work:

select * from majhist where jh_mjkey = 1 ;
AND jh_dateent = ;
(select max(jh_dateent) from majhist where jh_mjkey = 1)

BUT this does:

select * from majhist where jh_mjkey = 1 ;
AND ttoc(jh_dateent) = ;
(select ttoc(max(jh_dateent))from majhist where jh_mjkey = 1)


?????

Thanks,
Valerie