getting this error while loading data to DB table using import excel to DB smart service (conn=246144) Incorrect date value: '4/24/24' for column `Appian`.`bwauserdobcdt`.`dob` at row 1
Discussion posts and replies are publicly visible
Sonali Can you try this change in excel :-Format the date column with a custom text format (e.g., "m/d/yy") to display the desired format.Select your date column.Right-click and choose "Format Cells".Go to the "Number" tab and choose "Custom".Enter the code for your desired format (e.g., mm/dd/yyyy for "04/24/2024").
tried with custom format but not getting the exact value in DB some converted value is going to DB .
You have to format in expected value.Can you help us with example of yours.
I tested the below two formats m/dd/yyyy and d-mmm-yy but its giving error as below.
29-Apr-24 and 4/29/24
(conn=10647) Incorrect date value: '29-Apr-24' for column `Appian`.`bwauserdobcdt`.`dob` at row 1
(conn=10647) Incorrect date value: '4/29/24' for column `Appian`.`bwauserdobcdt`.`dob` at row 1