Help With SQL Query

[MikkoS]

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

[MikkoS]

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.

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

[MikkoS]

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

This one worked!