I am pretty sure that SQL Server 2000 is no different from any of the 

prior versions in this matter but I am unable to write the Date() entry 

out to a datetime field in SQL server.  I have tried Now() and Cdate(Date

().  I want it to hold both the date and time but am unable to do it.  I 

also tried placing ticks ' around it but that just converts it to a string 

and the field would be truncated when saving this.



Any help at all would be greatly appreciated. Thanks in advance for any 

assistance anyone can give.