to filter for Todays date + 7days

[keepcalm]

Hi Community,

I am trying to filter T+7 date. Eg if i run today (11/8/20), i need altyerx to capture only (18/8/20) date.I have tried to use date time tool to convert to a date and then use [Value Date] = todate(DateTimeAdd(DateTimeToday(),7,"days")) in filtering tool but it came out null. Any help? Thank you

[JosephSerpis · Accepted solution]

Hi @keepcalm I tested your syntax and it works for me. What format is the date data of the Value Date Column?