Flex DateField and MySQL default date value 0000-00-00?

I recommend that you store NULL for unknown dates, as opposed to '0000-00-00'. NULL is a more accurate value in this case.

I recommend that you store NULL for unknown dates, as opposed to '0000-00-00'. NULL is a more accurate value in this case. If you want to store it as NULL and display it as a different value you can do something like this: SELECT COALESCE(date_column,'0000-00-00') as formatted_date FROM your_table.

Thanks, you really putted me on the good path. – Jivago Mar 16 at 18:45.

Don't know if it will help somebody but I had trouble to insert values from a form, containing a DateField. That Form has been generated through the Flash Builder Generate Form tool. The problem is that the service generated by Flash Builder expect a Date Object, no matter what... If you submit the form without selecting a date in the DateField, the service call crashes.

Let's have a look at a part of the generated sample service (Create and Update functions), we can see that PHP is expecting to transform a Date Object to a String like this : mysqli_stmt_bind_param($stmt, 'sss', $item->friendname, $item->friendlastname, $item->friendbirth->toString('YYYY-MM-dd HH:mm:ss')); First of all, be sure that your Date field in MySQL has as NULL default value. Then alter the create and update functions like this : if ($item->friendbirth == null) $friendbirth = null; else $friendbirth = $item->friendbirth->toString('yyyy-MM-dd HH:mm:ss'); mysqli_stmt_bind_param($stmt, 'sss', $item->friendname, $item->friendnickname, $friendbirth); This way, the service call script won't try to do kinda null->toString('...').

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.