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.
Discussion posts and replies are publicly visible
How are you importing the data?
Can you share the code so that people can help further
By any chance are you having the column type in table as date?
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?
Importing the data using datastore and readexcelsheet function. The data will be stored in 3 different tables. So first I am storing the data in datastore and again I am storing the data in different tables using readexcelsheet function.
Yes. The column type is date in table
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.
Hi,
this might be some format issue that happens with the excel. you can try by formatting that date column in the excel to date and then try uploading the excel sheet.