O$: Today in Frontbase

Mike Matthews omnis at lineal.co.uk
Fri Apr 24 11:12:21 EDT 2009

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?


Mike Matthews

More information about the omnisdev-en mailing list