
Originally Posted by
Bruce1952
It does not work on future dates.
I did try to set the start date for two days earlier but when I updated it did not work either.
I just got this error message:
UPDATE salemaker_sales SET sale_name = 'CLEARANCE', sale_deduction_value = '20', sale_deduction_type = '1', sale_pricerange_from = '1', sale_pricerange_to = '700', sale_specials_condition = '0', sale_categories_selected = '2039', sale_categories_all = ',2039,', sale_date_start = '0001-01-01', sale_date_end = '20231109', sale_date_last_modified = now() WHERE sale_id = 24