DateTime data insert to sql server

[Shyam_Pragash]

Hi…

Using if condition
var ==System.Nullable<System.DateTime>

Assign Closed_Date =If( String.IsNullOrEmpty(Exl_Closed_Date.ToString),System.Convert.ToDateTime(DBNull.Value), DateValue(Exl_Closed_Date))

Error

Assign: Object cannot be cast from DBNull to other types.

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Dbnull cannot be converted …try assigning dbnull directly if it doesnot work then you have to assign a dummy date like 01/01/1900 00:00 so that you know it is a dummy date

Cheers

[Shyam_Pragash]

Hi @Anil_G

Null value is allowed…

i cant write dummy value in the DB.

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Can you try like this

If( String.IsNullOrEmpty(Exl_Closed_Date.ToString),DBNull.Value, DateValue(Exl_Closed_Date))

By giving only DBNull.Value

Cheers

[Shyam_Pragash]

Hi @Anil_G

As per ur advice.

i am getting complier error

whether i have to change the varable type or not ?

used variable type:

Thanks
shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Please change the datataype of the variable to object from datetime and check that shpuld solve it

Cheers

[Shyam_Pragash]

Hi @Anil_G

Still i am facing issue…

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

I still see date_Db as datetime type. Can you change that to object please

Cheers

[Shyam_Pragash]

Hi @Anil_G

Same issue.

Cheers

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Instead of using if like this …can you drag a if activity and assign both in two conditions please

This way you wpuld be able to assign for the old nullable datetime type also i beleive

Or try new object(DBNull.Value) repeat same for the date value as well

Cheers

[Shyam_Pragash]

Hi @Anil_G

I will check and Update u…

Thanks
Shyam

[Shyam_Pragash]

Hi @Anil_G

Unable to insert the data to sql server…

Thanks
Shaym

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Is it because we are using object or because of Null?

If it is because we changed to object now we can change to Nullable datatetime I believe as we are using a IF activity

If it is because of Null try to Give Nothing

Insert Null into a date database field via database execute query

Hi Ritesh, please find below example:- “DECLARE @test_value int EXEC @test_value = [dbo].[Tasktest] @testId, NULL, NULL, NULL, NULL, NULL, @ID OUTPUT” you need to directly pass “NULL” at the column position. no need to specify the column name. let me know if it clarifies.

can you show the error

cheers

[Shyam_Pragash]

Hi @Anil_G

Thanks :). i can able to insert the data in sql server…

but i have on issue… wrong data inserted to sql server…

Time is missing…

Thanks
Shyam

[Anil_G (Anil Gorthi)]

HI @Shyam_Pragash

Please use DateTimeValue(Variable) instead of DateValue

Happy Automation

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

cheers

[Shyam_Pragash]

@Anil_G

DateTimeValue(Variable)

DateTimeValue function not available… can u tell me how to add ?

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Try timevalue or a combination of datevalue and timevalue

cheers

[Shyam_Pragash]

Hi @Anil_G @RajKumar_DC

Thanks All

Finally we found the soluation to import Null data with specificed variable types in sql server.

If ( String.IsNullOrEmpty(Exl_Created_At), New Nullable(Of Date), System.Convert.ToDateTime(Exl_Created_At))

Variable Type : Nullable.System.Datetime

Thanks
Shyam

[william_joe]

The simplest method to insert the current date and time in MySQL is to use the now() function. Once you call the function, it returns the current date and time in the system’s configured time zone as a string. The value returned from the now() function is YYYY-MM-DD for the date and HH-MM-SS-UU for the time record.

Regards,
Will