At 07:39 AM 4/8/2004, jsWalter wrote: >is there a way to have mySQL auto insert the current DATE into a field when >a record is created, but when it's not updated? Nope - with mySQL default values of the column must be constants. http://www.mysql.com/doc/en/CREATE_TABLE.html "Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE." --- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."