I also realised that this notification will need to send on weekdays only. Where the email date does not fall on a weekday, I will need the email to send earlier (on Friday). What is the solution around this?

Hi, I need to set up a recurring delivery for a customer communications notice. The notice needs to go out 30 days before their renewal date. Is the correct expression "SubDays(@renewalDate,30)" equal to DateOnly(GetDate())? The written form of this is -  Query: Renewal date - 30 day equal to dateOn...