urgent help

[satishqlik]

Hi All,

The date format(DD-MMM-YY) is fine When  I read the data from QVD.

But when I exract the max date from the same QVD, it's not being fine.It shows in number format(41813).

Please can someone help me out in this where am wrong .

Thanks !

[swuehl · Accepted solution]

Nothing is wrong. Your date is a dual value, the text part shows the date formatted DD-MMM-YY, but there is an underlying numeric part.

Please read

Data Types in QlikView

Max() calculates the maximum number, returning a number. To format as date again, use Date() function:

=Date(max(DateField),'DD-MMM-YY')

[satishqlik]

Great!! Thanks swuehl for ur quik response.!