Hi team,
I have a native SQL field defined in the model:
paid_at: {
type: DataTypes.DATE,
allowNull: true,
},
In the layout, I chose the Date display widget, and the Date edit widget, with the format “DD/MM/YYYY”
I defined a smart action like this:
{
name: 'Mark as paid',
type: 'single',
endpoint: 'forest/actions/voucher_bills/single_mark_as_paid',
fields: [{
field: 'Paid_at',
description: 'Select the date at which the bill has been paid',
type: 'Dateonly',
isRequired: true,
}
I have a display problem on the default value of a Dateonly field.
When I initialize the default value with:
values: () => ({ Paid_at: moment().endOf('day') }),
The smart action opens with this display:
When I initialize the default value with:
values: () => ({ Paid_at: moment().endOf('day').format('DD/MM/YYYY') }),
Please look result at the video: the date is correctly displayed but month and days are inversed when opening the Dateonly picker (November is becoming August):
When I initialize the default value with:
values: () => ({ Paid_at: moment().endOf('day').format('MM/DD/YYYY') }),
It is correctly initialized, but displayed as an American format (not the French one),
and the displayed is of coursed once again inversed when clicking on the Dateonly picker.
Is it a bug? of else what is the right way to proceed?
Thanks in advance
My setup:
"database_type": "postgres",
"liana": "forest-express-sequelize",
"liana_version": "6.3.13",
"engine": "nodejs",
"engine_version": "12.13.1",
"framework": "express",
"framework_version": "^4.17.1",
"orm_version": "5.22.3"
