filter to previous day only

Hi,

For some reason when I try to filter data for previous day from today it appears blank. I cant see date format being the problem as it is in format altreyx uses.

Any suggestions, I have tried multiple other ways suggested online including adding column called 'yesterday date' then a using filter to equal report date = yesterday date but no luck on that either.

Workflow

Accepted answers

davidskaife

Hi @chiragpatel_1

If you only want it to filter on yesterday you don't need to write a formula, the basic filter has that option:

All comments

davidskaife

Hi @chiragpatel_1

If you only want it to filter on yesterday you don't need to write a formula, the basic filter has that option:

IraWatt

Hey @chiragpatel_1,

You need to convert it to a date, your function returns a datetime:

[Report Date] = ToDate( DateTimeAdd(DateTimeNow(),-1,"days"))

chiragpatel_1

wow didn't even notice that the basic filter is very underrated! thanks for the solution

chiragpatel_1

thank you, now I know how to make this approach works as well.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703