date format react editing date

dafer660

Hey,

I was trying to save date in a different format using the datepicker.

I tried to have the column like this:

id: 'date',
header: 'Date',
editor: {
	type: "datepicker",
	config: { format: "%d/%m/%Y" },
},
template: (value) => (dayjs(value).isValid() ? dayjs(value).format('YYYY-MM-DD') : ''),
width: 275,

However, it still stores as the following:

"2025-10-16T23:00:00.000Z"

Is there any way I could store as "YYYY-MM-DD"?

Many thanks,
Daniel F.

tasha

Hello dafer660,

To format date this way 'YYYY-MM-DD' using the datepicker you can use templateparameter of the columns property:

   {
      id: "date",
      header: 'Date - "datepicker"',
      width: 180,
      editor: "datepicker",
      template: (v) =>
        v
          ? v.toLocaleDateString("en-CA", {
              year: "numeric",
              month: "2-digit",
              day: "2-digit",
            })
          : "",
    },

Please check the example: https://stackblitz.com/edit/vitejs-vite-6vtvrbmn?file=src%2FGridComponent.jsx