to filter for Todays date + 7days

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

Workflow

Accepted answers

JosephSerpis

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

All comments

JosephSerpis

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703