topic Re: urgent help in QlikView https://community.qlik.com/t5/QlikView/urgent-help/m-p/836901#M998005 <HTML><HEAD></HEAD><BODY><P>Great!! Thanks swuehl for ur quik response.!</P></BODY></HTML> Tue, 16 Jun 2015 23:18:05 GMT satishqlik 2015-06-16T23:18:05Z urgent help https://community.qlik.com/t5/QlikView/urgent-help/m-p/836899#M998003 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>The date format(DD-MMM-YY) is fine When&nbsp; I read the data from QVD.</P><P>But when I exract the max date from the same QVD, it's not being fine.It shows in number format(41813).</P><P></P><P>Please can someone help me out in this where am wrong .</P><P></P><P>Thanks !</P></BODY></HTML> Tue, 16 Jun 2015 23:03:02 GMT https://community.qlik.com/t5/QlikView/urgent-help/m-p/836899#M998003 satishqlik 2015-06-16T23:03:02Z Re: urgent help https://community.qlik.com/t5/QlikView/urgent-help/m-p/836900#M998004 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Please read</P><P><A href="https://community.qlik.com/qlik-blogpost/2830">Data Types in QlikView</A></P><P></P><P>Max() calculates the maximum <EM>number</EM>, returning a number. To format as date again, use Date() function:</P><P>=Date(max(DateField),'DD-MMM-YY')</P></BODY></HTML> Tue, 16 Jun 2015 23:10:01 GMT https://community.qlik.com/t5/QlikView/urgent-help/m-p/836900#M998004 swuehl 2015-06-16T23:10:01Z Re: urgent help https://community.qlik.com/t5/QlikView/urgent-help/m-p/836901#M998005 <HTML><HEAD></HEAD><BODY><P>Great!! Thanks swuehl for ur quik response.!</P></BODY></HTML> Tue, 16 Jun 2015 23:18:05 GMT https://community.qlik.com/t5/QlikView/urgent-help/m-p/836901#M998005 satishqlik 2015-06-16T23:18:05Z