I just thought of something else that could be causing that problem<BR><BR>1. Remove the SINGLE QUOTES in your insert statement around the DATE Variable if you have any.<BR><BR>2. You may need to add the "#" sign around the date insert, but try this last.<BR><BR>3. Double check to make sure that the table field for this variable insert is Date/Time - If it is then change that field to TEXT. Test it. if it works then you know it is because the value of the date function that is being stored is not a valid entry for the Date/Time field type or the syntax of the statement is wrong.<BR><BR>Hope that helps.