Getting the last date value

[TormentMaker]

Hey guys, so i got a problem with my project in alteryx, actualy i wanted to do some formulas and stuff with data using datetime(datetimeadd -1) thing, but i noticed that isn't everyday that my database will update so, i need to get the last day present in the database, something like:

26/05/2021	Wood Chair
18/05/2021	3 seats couch
26/05/2021	Couple bed
26/05/2021	Oven
25/05/2021	Glass table

What i need is a way to get only the last day present in the table, like if i was doing it with this actual data, it would be 26/05

Someone could help me?

[atcodedog05 · Accepted solution]

Hi @TormentMaker 

Here is how you can do it.

1. use summarize max on date to get last date.

2. Join date on last date to get data only of last date

Hope this helps 🙂

[TormentMaker]

Yep that helped, thanks buddy