O$: Today in Frontbase

[Mike Matthews]

Hello FB users,

After reading the docs a bit, I have tried to find the reserved word  
that means TODAY.  I have tried CURDATE but no joy.  I want to find  
all records with a DateTime field whose date part is TODAY.  It may be  
a mismatch with it being DateTime though.

'WHERE tablename.DIARY_DATE = [#D]' doesn't work in my fetchall.

Any answers please?

Thanks

Mike Matthews