Date Field stored as null in database

Question

Hi everyone, 
 After importing the data from excel the values of date fields present in the excel are storing as null values in the datastore and in database too. 
 Any help here. 
 Thank you.

Mike Schmitt · Answer

Agreed with Kumar - we need more detail. When you say "importing the data from excel", what was the source of the excel data? What data type were the date column(s) stored in? What method did you use to "import" it? How did you vet in advance that whatever import method you used would cast dates correctly from the format contained in the Excel file to the DB?

Soma · Answer

Please change all the columns in the database table to varchar() then the import will succeed. And you will have all your data from excel in the staging table as text. Then you can manipulate the data as per your need.