Filter data for previous day

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?

Date Time

Time Series

Accepted answers

JosephSerpis

Hi @mercurial_maverick that is probably because the date formats are not the same can you try this syntax in the formula tool. Datetimeformat(Datetimeadd(DateTimeToday(),-1,"Day"),"%Y-%m-%d")=DateTimeFormat(DateTimeParse([tm],"%Y/%m/%d"),"%Y-%m-%d") . If that does not work I suggest create two new columns in a formula tool one with the date column with your database. The second column with the previous date you want to filter, you can use the syntax in the filter tool from my previous post to create that then use those columns in the filter tool. This should help troubleshooting and ensure you have no issue with different date formats.

All comments

JosephSerpis

Hi @mercurial_maverick I mocked up a workflow let me know what you think?

Append_Data_20072020.yxzp

AshleyL

Hi @mercurial_maverick!

You have a few options here! The easiest way to filter to just previous day's data is probably using a formula building block to get yesterday's date and then filter it from there. You can then go on to appending the excels: