Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

maximum date issue

Hi

I have below date format 

Date:

1/12/2022 12:00:00 AM

12/25/2016 12:00 :00 AM

3/28/2000 12:00:00 AM

 

I am trying to get the MAX(Date) but it is not returning '-' not the date.

 

Regards,

Faizan

Labels (1)
2 Replies
Saurabh_K14999
Contributor III
Contributor III

Hi,

Use the below expression in Load Editor

Date(max(Date),'DD/MM/YYYY') as NewDate

 

Regards,

SK

Bill_Britt
Former Employee
Former Employee

Hi,

If you are looking for it in the script you can do something like below

Where Orderdate is the Field and Orders is the table

LET varMaxDate = num(Peek('OrderDate',-1,'Orders'));

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.