Scheduled Mail

[Mangesh_Mundhe]

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

[Suvrutt_Gurjar]

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