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 dateOnly(current date)