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’

I would like to automate this as opposed to forcing a ‘2024-12-31’ date, then having to change the code again in 2025, 2026,…

Thanks in advance for any assistance.