Help With SQL Query

Hi,

I have a problem with SQL- query that works well in MySql editor but not in Uipath. Although in SQL side i used direct values instead of variables. So how should i type this one to execute query?

Select * From payroll_periods
where payroll_start_date between “strvariable” and “strvariable” and customer_id=strvariable;

Thanks,

Mikko

It throws error for the right syntax. We are using MySQL here.
This query in SQL Editor gives me correct result. I tried to add “;” also to the end. :slight_smile:

SELECT * FROM payroll_periods
where payroll_start_date between “2020-08-01” and “2020-08-15” and customer_id=35;

“Select * From payroll_periods Where payroll_start_date between '”+strFirstDate+"’ And ‘"+strLastDate+"’ And customer_id=’"+CustomerID+"’;"

This one worked!

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.