filter to previous day only

[chiragpatel_1]

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.

[davidskaife · Accepted solution]

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.