peter mostmans asked 12 years ago
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'
Abu Ghufran answered 12 years ago
We'll recheck this issue, and update ticket when done.
Thanks for reporting.
Abu Ghufran answered 12 years ago
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');
Steven answered 12 years ago
I'm evaluating this product, but having the same problem. Please advise. Thanks.
Abu Ghufran answered 12 years ago
Hello Steve,
I'll be releasing an updated free version soon. This would resolve it.
Follow on twitter / g+ to get update.
