I need help with a query that when criteria is met to update an end date to 12-31 of the current year.
In addition, the format would need to be: ‘yyyy-MM-dd HH:mm:ss’