Filter data for previous day

[mercurial_maverick]

Hello all,

I'm have existing alteryx workflow which publishes output to an excel file. Currently there is data in the excel file from previous runs. I need to add in a filter tool for the field "date" to filter for only previous day's data and append to the excel file. For example, tomorrow when I run the workflow it filter for date = previous day and append previous day's data to the output file. any idea how to achieve this using the filter tool?

[MChung]

@JosephSerpis 

Hello Joseph, 

I am having this exact problem. I would like to output a table that is only showing the previous day's data. For example, "how many interviews were conducted by Group A yesterday?" Mimicking the formula in this thread is giving me errors. The format for the date field on my report is written as, "2020-08-13". How would I use the formula to output the data that I need? Thank you in advance.