how can I write this update better?
A query to check if a specific date falls on a weekend and if it does update the date to the monday following the weekend. Ex: date = 6/15/2024. This falls on a saturday. Update the date to 6/17/2024.
A query to check if a specific date falls on a weekend and if it does update the date to the monday following the weekend. Ex: date = 6/15/2024. This falls on a saturday. Update the date to 6/17/2024.