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,

May be like this:

MaxString(publishdate) or MaxString(Date#(publishdate))

[its_anandrjs]

Try in place of Max you use Maxstring(publishdate)

Regards

Anand

[#4]

Hi,

Create a apply map to get the max date date and add to the  main table from the script itself.

Regards,

Sijo

[ashfaq_haseeb]

Hi,

try Maxstring(publishdate).

If not post sample data to look over.

Regards

ASHFAQ

[MK_QSL]

What is your PublishDate format?

i.e. DD/MM/YYYY or DD-MM-YYYY or something else?

[#7]

even  above mentioned all r not working..  getting calculation error

MaxString(publishdate) or MaxString(Date#(publishdate))

[#8]

format is  ' DD/MM/YYYY'

[MK_QSL]

Try something like below

=Max(Date(Date#(publishdate,'DD/MM/YYYY')))

[ashfaq_haseeb]

HI,

can you post sample data?

Regards

ASHFAQ