I just converted my Access 97 database to SQL Server 7. I have 2 questions about this.<BR><BR>1. Does SQL Server recognize functions such as Date() or Time()?<BR><BR>2. When trying to insert Date() into a date/time field, SQL Server seems to insist upon putting a time value next to the date (and vice versa when trying to insert Time()). How do I avoid this and still remain a date/time type?<BR><BR>Thanks!