Requirement is that I need to send the Scheduled emails daily if the date of departure of a person is 7 days or less from today ......so lets say today is 19th may so if the person is going to travel on 26th may i need to send the mail daily till departure date is passed.
I tried this but giving me the error , How can i write this expression to get the desired output ?
Thanks in advance
Please try
HOUR([Departure Date]-TODAY())/24 < 7
Please check the section "Examples that compute Durations in Days, Months, or Years" in the article below.
https://support.google.com/appsheet/answer/10107326
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |