UPDATE tbl_careauditsallcompleteaudits
SET date = REPLACE(date, '2024', '2023')
WHERE date LIKE ('2023');



UPDATE tbl_scheduledaudits
SET startdate = REPLACE(startdate, '2024', '2023')
WHERE startdate LIKE ('2024');