Answers

• allan Posts: 65,233Questions: 1Answers: 10,812 Site admin

  September 2016

  There are two options:

  1. Use the ISO format as the "wire" format (i.e. what is in the JSON) and a renderer to make it readable to the end user in the table.
  2. Have both the ISO and the formatted version in the JSON. DataTables would be told to show the formatted version, while Editor works off the ISO format.

  Regards,
  Allan
• StevenRaekelboom Posts: 5Questions: 2Answers: 0

  September 2016

  Hi Allan

  Thank you for your answer.
  In fact I was already using a renderer in the table:

   "columns": [
     {
      "data":"Date_created",
      "type":"date",
      "render":
          function(data, type, full) {
            return (data) ? moment(data).format('DD/MM/YYYY') : '';
          }
     }
    ],
  
  

  and it displays correctly. It is when I activate the inline edit that the display changes to the format that is defined in the editor so it shows f.i. 2016-09-06 and if I define a format for the editor, it will also use that value to send to the server.
  In the library I was using before I had the possibility to define a viewformat which fit my purpose. I was hoping to find something similar in editor.
  Sorry for being unclear before.

  Regards
• allan Posts: 65,233Questions: 1Answers: 10,812 Site admin

  September 2016 Answer ✓

  I understand - thanks for the clarification. Unfortunately, at the moment Editor's datetime field does not support two different formats (wire and display). It uses the same format for setting and getting.

  That is something I would like to add in future, but it isn't available yet I'm sorry to say.

  Allan