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?

[Shree185]

Hi @Jose 

I am trying to apply the same filter with today - 7 days, can you please help me

[nagakavyasri]

@Shree185 Use -7 in the formula: todate(DateTimeAdd(DateTimeToday(),-7,"days"))

[vivaisun11]

Hi @nagakavyasri - same question, but how do I do it for all days between the current date and 7 days prior to the current date?

Meaning if today is Nov 1st, I'd like to filter all dates between October 25th and Nov 1st.

Thanks!