Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i have a publish date() column.. in that each id have multiple dates. but i need to show up only latest publish date in my table.
how can i get latest date in my table. when i used max(publishdate) am not getting.
please help me out.
Hi,
Try like this:
=aggr(MaxString(publishdate),id)
try this
firstsortedvalue(id,-publisheddate)
Hi,
You can create a new table with the field MaxDate to get your max(date).
Example:
Table1:
Load
A,
B,
Date(Date) as Date
From
YOURTABLE;
Table2:
LOAD
Date(Max(Date)) as MaxDate
Resident
Table1;