i am inserting data from excel to data base. The exact column is in this format 31-12-2023 .for that i am using assign activity vdata=currentRow(3).tostring and in query “+vdate.tostring+”.
but i am getting value like 12245. and format of that perticular column in Database is datetime format. thats why i am getting error…where should i chage? in assign activity or in querry.?..please help.
can you please share the entire query which you are used and how the values you are getting
Instead of passing as a String datatype try to pass it in datetime datatype.
- Assign -> vdata = DataTime.ParseExact(CurrentRow(3), "dd/MM/yyyy", System.Globalization.Cultureinfo.InvariantCulture)
The vdata is a DateTime datatype variable.
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.