Hello,
Can you confirm the data format that a date column needs?
I have a "Due Date" column that I have tried using both a datetime and date value (defined/populated from an SQL database) and no data is displayed in the column. If I remove the type: 'date' property from the column definition the unformatted date or datetime is displayed without issue.
columns: [
{ text: 'Order', field: 'reference', width: 120 },
{ text: 'Stock Code', field: 'name', width: 100 },
{ text: 'Description', field: 'Description', width: 150 },
{ type: 'number', text: 'Qty Outstanding', field: 'QtyOutstanding', width: 120 },
{ type: 'date', text: 'Due Date', field: 'DueDate', width: 100 }
]
Examples of the data I have tried to populate the column with:
{""id"":2265,""reference"":""52250003"",""name"":""ABC123"",""Description"":""Test Part"",""QtyOutstanding"":100.000000,""DueDate"":""2023-07-10""}
and
{""id"":2265,""reference"":""52250003"",""name"":""ABC123"",""Description"":""Test Part"",""QtyOutstanding"":100.000000,""DueDate"":""2023-07-10T00:00:00""}
Thanks for your help