Issue with Formatting Date and Handling Date-Only Values in Sequelize

[DilharaSannasgala]

Hello,

I'm encountering an issue with formatting dates and handling date-only values in Sequelize. Despite defining the assign_date field in the assignment Sequelize migration file with the SEQUELIZE.DATEONLY type, I'm having trouble ensuring proper formatting.

Here's a snippet of the relevant code:

const assignData = {
    assign_date: req.body.assign_date,
}

const schema = {
    assign_date: { type: "dateOnly", empty:false, messages: { required: "Date is required" } },
};

const validatorInstance = new validator();
const validationResponse = validatorInstance.validate(assignData, schema);

Could someone guide how to properly insert date-only values into an SQL database via Sequelize?

For instance, if the input date is in the format 2024-04-15 but the database shows 2024-04-15 00:00:00, I aim to format it as 2024-04-15.

[sasankadeshapriya]

Hi, I also faced, I resolved it by following these steps:

Remove assign_date from Sequelize schema. Validate it as required in the Flutter form.
Format date in backend: After receiving the date, format it in the backend before insertion using below code snippet:

const assignDate = new Date(req.body.assign_date); 
const formattedDate = assignDate.toISOString().split('T')[0];

const assignData = {
   assign_date: formattedDate,
}

Then Save.
I believe it will work.

[DilharaSannasgala]

checking

[sasankadeshapriya]

ok

[DilharaSannasgala]

@sasankadeshapriya Thanks it's work