SQL Date to DateTime object

Help
1

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?

2

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())
3

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

4

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”))