Not able to get Min and Max values of a Date field

[komminenianusha]

Hi All,

I am new to qliksense. I am working on QV to QS migration.

in QV scripting they created one date field using SQL like below

TO_CHAR(TO_DATE('01011970','ddmmyyyy') + 1/24/60/60 * TIMESTART,'DD/MM/YYYY')  as "TIMESTART_SESSION",

Same code I am using in QS also but while trying to fetch 'min' and 'max' value of that field by using Min and Max functions I am not getting any values. The field is empty  if I apply 'num' function also.

Can any one please help me to find out the route cause for this issue. Why I am not getting values ?

Thanks in advance.

Regards,

Anusha

[tresesco]

When you load the same in qlik, how does (date format) it look at the UI?

[komminenianusha]

Date format like 'DD/MM/YYYY'

[tresesco · Accepted solution]

Try like:

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

[komminenianusha]

It works fine. Thank you very much Tresesco.