SQL Date to DateTime object

Hi, I have a field of type date in SQL. I have it as one of the columns in a DataTable. How do I use this date as a DateTime object in UiPath Studio?

Hi @DEATHFISH,

Try like this, Here I assumed that you read the data in a datatable and looping it as datarow and order_date is your date column in the datatable.

Convert.ToDateTime(dataRow("order_date").ToString())

please dont do that, why would you take a datetime variable, convert it to string and then convert back to datetime?

If you already have the datatable object then to use one of the columns as DateTime, you only need to cast it, if you create a DateTime variable in UiPath, then it looks like this in Assign:
date1 = CDate(dt11.Rows(0)(“MyDateColumn”))