Bubble editing date field

Bubble editing date field

shanks@gma-cpa.comshanks@gma-cpa.com Posts: 1Questions: 0Answers: 0

I've got a table using DataTables that I'm populating via an Ajax call. I'm displaying two date fields per record in the table. I've gotten them displaying correctly (MM/DD/YYYY), but when i do an bubble edit, it shows as 2016-10-31T00:00:00. How can I change the way the data is displayed to match the normal display values?

See attached image.

Any help will be greatly appreciated

Replies

  • allanallan Posts: 61,723Questions: 1Answers: 10,108 Site admin

    The editing field will show whatever format the JSON data that is used to populate the field contains. It sounds to me like the JSON data contains a full ISO8601 string, and you are using a column renderer for the DataTable to format the data into a readable string. Is that correct?

    What I would suggest is that you format the data string at the server-side so it is in the format you want in the JSON data. The PHP and .NET libraries for Editor provide formatters for this.

    Regards,
    Allan

This discussion has been closed.