topic Re: maximum date issue in QlikView

maximum date issue

Mahamed_Qlik — Thu, 10 Nov 2022 08:04:26 GMT

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 — Thu, 10 Nov 2022 10:00:07 GMT

Hi,

Use the below expression in Load Editor

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

Regards,

Bill_Britt — Thu, 10 Nov 2022 11:40:49 GMT

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