Send mail IF condition is TRUE

Help Studio
, ,
1

Hi All,

I want to send mails IF the condition is TRUE.

Condition : Send mail before two weeks from review date.

Eg: IF review date is “01/08/2022”, I want to send mails before two weeks i.e on
“18/07/2022”

FYI. Review date is available in excel.

Please help. Thanks in advance.

2

Hello!

To get the date corresponding to 14 days before a reference date, use the AddDays method as in the example:

image
image835×427 14.3 KB

3

Hello @devanand.1292

If review date is 01/08/2022 you want to send an email of before two weeks. But I couldn’t understand what is the condition that you are trying to check here. Could you please elaborate more