Where clause + VB

[cptcanada]

Why does it say WHERE DATE()>date_des troyed is not a roconized function in VB?

Thanks for the help

[jeffstl]

Why does it say WHERE DATE()>date_des troyed is not a roconized function in VB?

Thanks for the help

That should be part of your SQL string. VB Should not be compiling it.

Nevertheless the SQL date functions do not work like that. You need :

Select CURRENT_TIMESTA MP (or CURRENT_DATE or CURRENT_TIME)

Kind of depends on what you want to do and what kind of database server you are using (Access, MySQL, etc)