How to insert empty value in datatable date time column

Help
1

Hi Folks,

When i try to insert a data row to data table, i am not able to leave blank for the column (with data type → date time). When i assign to “”, i will get the following error → " Add data row : String was not recognized as a valid DateTime.Couldn’t store <> in variable1 Date Column. Expected type is DateTime."

I tried to search in google, which recommend me to use sqldatetime.null, but I am not able to assign sqldatetime.null in UiPath.
https://forums.asp.net/t/2101594.aspx?How+to+insert+empty+value+in+datatable+date+time+column

Can you someone shed some light? Thanks in advance

1 Like
2

Hello!

Have you tried to use ‘nothing’?

nothing is the Null of VB .NET :wink:

Hope it Helps.

Regards,

9 Likes
3

And nothing works perfectly ! thanks

1 Like