Update BMQL getting Error while passing Date parameter in where clause

Summary

Update BMQL getting Error while passing Date parameter in where clause

Content

Dear All,

We Are trying to update the record which has the current date in between start date and end date.

---------------------------------------------------

currentDate=datetostr(getdate(), "MM/dd/yyyy");

results = bmql("update Party_Part_Price set $set1 where part_number = $partnum and customer_id = $distributorNumber and quote_number is not null and  (to_date(start_date,'mm/dd/yyyy')<=to_date($currentDate,'mm/dd/yyyy') and to_date(end_date,'mm/dd/yyyy')>=to_date($currentDate,'mm/dd/yyyy')");// where start_date and end_date are the table fields