Return most recent date

Hello!

I have a request to automate a repot for a colleague. The issue I am having is that the data in this report is usually about 48 hours old.

Is there any way that I can tell Alteryx to just return the most recent day's worth of data? I have everything filtered down, but it's returning all the days within the table.

Thanks!

Date Time

Preparation

Accepted answers

JoeM

Here is another approach that might be worth trying:

Use a summarize to find the max_date and join that back to the dataset to find all the data from the latest day

LatestDate.yxmd

All comments

JohnJPS

Sure! In the Filter tool, compare a date from your DataSet to "DateTimeToday()" or "DateTimeNow()" which can be found under the DateTime functions.

Colejweinman

I'm sorry, I'm a bit new, can you explain what you mean by 'Compare'?

JoeM

Here is another approach that might be worth trying:

Use a summarize to find the max_date and join that back to the dataset to find all the data from the latest day

LatestDate.yxmd

Colejweinman

Thank you, Joe!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703