date field problem

Questionsdate field problem
peter mostmans asked 11 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'

5 Answers
Abu Ghufran answered 11 years ago

We'll recheck this issue, and update ticket when done.
Thanks for reporting.

Abu Ghufran answered 11 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 11 years ago

I'm evaluating this product, but having the same problem. Please advise. Thanks.

Abu Ghufran answered 11 years ago

Hello Steve,

I'll be releasing an updated free version soon. This would resolve it.
Follow on twitter / g+ to get update.

Steven answered 11 years ago

Hello Abu,

I'm following on twitter.

Kind regards,

Your Answer

16 + 12 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?