Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

12 Replies
Not applicable
Author

Hi,

May be like this:

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

its_anandrjs

Try in place of Max you use Maxstring(publishdate)

Regards

Anand

Not applicable
Author

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
Champion III
Champion III

Hi,

try Maxstring(publishdate).

If not post sample data to look over.

Regards

ASHFAQ

MK_QSL
MVP
MVP

What is your PublishDate format?

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

Not applicable
Author

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

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



Not applicable
Author

format is  ' DD/MM/YYYY'

MK_QSL
MVP
MVP

Try something like below

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

ashfaq_haseeb
Champion III
Champion III

HI,

can you post sample data?

Regards

ASHFAQ