Hi everyone,

How do you compare only the date part of datetime fields?

I tried examdate = GETDATE() and it does not compare to =. I compared examdate = '10/13/2002' and its equal. Is it comparing the time also?

What is the proper code to compare only the two dates without the times in an SQL Query Criteria?

Thanks
Roland