Visual Basic SQl statement

Hi all,
I'm trying to run a sql statement using ODBC through a VBA.  The Database on
the 400 has a Numeric field defined 8.0p(used as a date field).
i've created a SQL statement that lets me select records from the file,
however, when i try to condition the select based on the date field i get
cryptic errors.

ideally i'm trying to select the data based on the current date.  However,
since i couldn't get that to work, i thought i would just try DATEFIELD > 0,
that doesn't work either.

Here is my select statement.
  SQLstr = "create view DISPATCH_V as select * from UFDB,UFDBS,UCSRFD where
PZBSB = P1BSB and P1MTR = PWMTR and PZBSB > 0"

can someone tell me what i might be doing wrong.
also if i want to change the sql to PZBSB = Curdate(where curdate is a
variable) is there anything special about doing that.

Thanks

Mike