Automate send email with date for both header and body

hi all

May i ask if i wld like to send a scheduled email with header and body that contains date… eg
header" report for 15/10/20 to 18/10/20"
and
body “Hi all pls find the attached report from 15/10/20 to 18/10/20” …
so by next week the date will change to 22/10/20 to 25/10/20…
How can i do that?
thank u :slight_smile:

@Lew_Sin_Tat

(date.Today.ToString(“dd/MM/yyyy”) +“to” + (System.Date.today.AddDays(7).Date).ToString(“dd/MM/yyyy”))

This will give 14/10/2020 to 21/10/2020

@Lew_Sin_Tat
did it work?