I tried to insert a record into the database with the FormatDateTime(Date(,)1) syntax, unfortunately the date inserted was shown as 01/01/1900. I have used the formatdate... function before on another database and the insertion worked just fine. I would like to know if the date and time has to be set up on the database, if it does how do I do this <BR>thankyou