How to get UiPath to accept a date range and enter that range into a SQL query

[hall1570 (Christopher Hall)]

Hello Masters,

I’m having a little trouble with a particular operation. I have a workflow that accepts a date range as a variable which I am posting below.
Main.xaml (8.9 KB)

I want to use this date range in an SQL query to import over all of the rows of data within that date range. I am posting a sample data table below.
Jaywalking Data.xlsx (15.6 KB)

How can I get my input variable in UiPath to work in my SQL code? Since I am new, would you please post the xmal in your answer?

[Palaniyappan (Forum Leader)]

Hi
Did we try with this method buddy

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

Cheers @hall1570