DateTime data insert to sql server

Help Studio
, ,
6

Hi @RajKumar_DC

i have input file in excel file…that input excel details insert into SQL Server Database…

i have written the DB connection and Script for insert the data.

excel file —> for each activity —> using assign the value

“INSERT INTO HF_master_1 (”“Date”“, ““Closed Date””, ““Created At””) Values (@Date_BD, @Created_At, @Closed_Date)” – for Date columns to be inserted.

Since the excel cell has the date format defined but values were inserting blank and in some cell it is getting inserted with date and time.

Error:

Main.xaml: Compiler error(s) encountered processing expression “Closed_Date”.(2) : error BC30512: Option Strict On disallows implicit conversions from ‘Date?’ to ‘Date’.

Thanks
Shyam