[AccessD] Convert SQL Server Date/Time to Date

I have an access database linked to an SQL server table. SQL server
stores a time with the date. I want to extract only the date part when
using this field in a query. I know I have done it before but can
someone refresh my memory. Thanks.

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.