maximum date issue

[Mahamed_Qlik]

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

[Saurabh_K14999]

Hi,

Use the below expression in Load Editor

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

Regards,

SK

[Bill_Britt]

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'));