insert current date

I have a mysql table with several fields one of which is of a type date, in the past I am sure I could on inserting a record set the default value to the current date using NOW(). When I try this now I get an error saying incorrect value for my date field, even setting the default value in the data table itself gives me this message. What am I doing wrong , I am using MySQL version 5.1

Try inserting the current date and see if that works:
date-and-time-functions.html#function_curdate

The now function returns the date and the time, so that may be the issue.

Tried that and just about anything else I can think of. Using phpmyadmin I have tried just about every SQL function call I can think of and they all return "invalid default value for field type"
I have tried it on my local install and my webhost's install of mySQL and comes back the same invallid default value.

Thanks
Keith

Are you setting this as the default value or are you using the now function call in the query that you are using to insert the values?

According to this post in MySQL forums (although it is a bit old), you should not set the default value using the function call:
bug.php?id=2539

Jimmy
I have tried both ways setting it as default in the database table and also as a function call in datassist insert record , using now() or current_date() date() they all return an error stating that the value for my date field is incorrect this is what the message acctually says

Incorrect date value: 'NOW()' for column 'picadddate' at row 1

I have attached the page source and the SQL for the table in question

Thanks for your help
Keith

Jimmy
I have since tried a few things and if I change the data type to datetime for the field in the database and do an insert using phpmyadmin and curdate() as the value it works fine, but if I try and do the same from datassist insert I get the same error message as before.

Any ideas

Keith

It could be an issue of format that the date is in. After getting the curdate, try formatting it using the dateformat function:
date-and-time-functions.html#function_date-format