Ok i want to select records that havent expired i.e.

WHERE dtdateexpires >= getdate()

problem is dtdateexpires sometimes have date and time and other times just
date. how do i get it to include the ones which dont have a time ?

help appreciated

I dont know exactly how to go about it, but you could convert both variables to match the same date format. I think you can do this in a query, but was unable to figure it out in a few moments and gave up.

Just a thought... Good luck!

--------------------
MtnManDan

www.curiouscal.com