Value of Date Variable Coming in Number Format

[sunitha_chellaiah]

Dear All,

While using below mentioned expression, value is coming in number date. It should come in Date format.

=$(=Max(DOJ))

I want to use this expression in set analysis. So I am testing this in text object. Kindly see below screenshot.

Value should come as 28-06-2021. But here it is showing -1999.

Please help me to correct the expression.

Thanks in advance.

[tresesco]

Thank you very much HIC for the clarification. 

I also find that in Qlik Sense, 'Auto' format takes the Number format while it is still a dual value. 

[sunitha_chellaiah]

Hi @hic ,

I got the correct value now by using this expression.

='$(=Max(DOJ))'

Thank you so much.