Issue with date retrieval from database?

I picked date using datetime input component and saved in database:
image

now when I am retrieving it using following query to perspective table its showing wrong value:
SELECT expense.expenseId,
expense.employeeName,
expense.description,
expense.job,
expense.cdnTotal,
expense.usdTotal,
expense.euroTotal,
expense.expenseDate,
expense.selected
FROM expense

image

Thank You

You’ll need to configure the props.columns section of your table. The props.columns[x].field should be equals to the column name, set your props.columns[x].dateFormat as you like and if needed, force the props.columns[x].render to date.

1 Like

Since data is fetched from database there is no props.columns

i added columns and tried still not working
image

The props.columns can be auto generated by your dataset with the system.dataset.getColumnHeaders. If you want to have some flexibility on your table, the columns attribute is the way to go.

1 Like

You need to set the field with the column’s name.

2 Likes

Thank You so much you solved my two issues with this.