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?
Solved! Go to Solution.
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 🙂
Yep that helped, thanks buddy