Excel Datetime Issue

Hi Team,

I have an excel sheet with columns Name and Date.

When I am using excel loop to read the data and insert data into DB, and if the Date column is empty in a row, date is inserting in DB as 01/01/0001 instead of null.

When I am trying to convert that excel to datatable using import Datatable instead of excel loop date is displaying as 30/12/1899 instead of empty.

Please let me know how to add empty row for datetime if the column is empty.

Below is the excel :



A product patch has already been released for same for enterprise edition. Request to kindly get in touch with Support team to get required patch


Hi Amit,

My Enterprise edition version is latest only, but still facing same issue, Can you please provide the patch name so that i will connect with Support Team.