how can i get latest date(Max Date) in my date column

[#1]

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.

[#2]

Hi,

Try like this:

=aggr(MaxString(publishdate),id)

[#3]

try this

firstsortedvalue(id,-publisheddate)

[Anonymous]

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;