I have the default date set on my fields in SQL Server using getDate().<BR>However this gives me the time with the date. I only want the<BR>date. No time.<BR><BR>I am plenty aware of the VB conversions for time. But I want to know how to set SQL server to default to Date only in my fields when new records are entered.<BR><BR>Thanks,<BR><BR>Paul