I have a column in a mysql database, datatype 'Date', which is format (yyyy-mm-dd). I want to show the field in the grid 'dd-mm-yyyy'. When adding a record and picking a date from the datepicker, it inserts the value as 'yyyy-mm-dd' (whatever I do with the $col['formatoptions'] or $col['datefmt']. And I want it to show 'dd-mm-yyyy', while adding it correctly in the database as 'yyyy-mm-dd'
This issue is resolved. In your case, following config will suffice.
Also sending you updated lib.
$col["formatter"] = "date"; // format as date
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d/m/Y');
I'm evaluating this product, but having the same problem. Please advise. Thanks.
I'll be releasing an updated free version soon. This would resolve it.
Follow on twitter / g+ to get update.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?