Does this help?
not dtfield is null or dtfield < '12/31/2004'
>hello,
> I am using the sqlexec() to send a sql statement to an access database. I am having problem to pass the value for one of the date field. what would be the correct syntax for if not empty for this date field or anything is greater than a value for a date field?? Thank you..
>
>Sherry
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown