Highlighted

Recurring delivery - Query help

CarinaL

14-03-2018

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)

Replies

Highlighted

eveline8

14-03-2018

Hi,

i suggest you to use the function ToDate() that converts a date + time as a date.

So I think that the correct expression becomes ToDate(SubDays(@renewalDate,30)) equal to ToDate(GetDate()).

In this way, remove the time from both fields (in case it is present).

Eveline

Highlighted

CarinaL

14-03-2018

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?

Highlighted

davidl14970702

14-03-2018

Should be able to use a scheduler to define those options. Set it to delivery daily then it will allow you to pick which days of the week you want.