how to format a date field inside a datatable

Webix JS
1

hi, i need to know how to format a date field inside a datatable because its saving the date field like: 2019-12-31T06:00:00.000Z
and i dont need the time part, only the date part is what i need, this is my code:
and as you can see im using the format: webix.Date.dateToStr("%y-%m-%d") but its not working , so i need to find a way to save only the date part from this date component.

    {
      view: "datatable",
      id: "iddatatablecursos",
      autoheight:true,
      columns: [
        {
          id: "idcurso", editor: "text", header: "Nombre del curso", width: 150,fillspace:true
        },
        {
          id: "idinstitucion", editor: "text", header: "Institucion", width: 150,fillspace:true
        },
        {
          id: "idfecha", editor: "date", header: "Fecha", width: 150, format: webix.Date.dateToStr("%y-%m-%d"), fillspace:true
        }
      ],
      select: "row",
      editable: true, 
      navigation: true,
      editaction: "dblclick",
      data: []
    }
2

i fixed in the backend doing the next in sql server:

cast(?lctxtfechatitulos as varchar(10))

i read it in a post here at webix, but i stil dont understand why in a datatable with a date field component it records the date with time part even if i formated it, it seemd like sometimes this line wont work

format: webix.Date.dateToStr("%y-%m-%d"),

3

i forget to mention that the field in the table is in varchar format

4

Hello @Lalo,

i read it in a post here at webix, but i stil dont understand why in a datatable with a date field component it records the date with time part even if i formated it

The column’s format will simply set the visual representation of the incoming data, without modifying it in any way. If you’d like to modify the data being sent to the server, you can do so via a scheme:

scheme: {
  $save: function(obj) {
    let format = webix.Date.dateToStr("%y-%m-%d");
    obj.idfecha = format(obj.idfecha)
  }
}