topic Re: text object in QlikView https://community.qlik.com/t5/QlikView/text-object/m-p/1345443#M846518 <HTML><HEAD></HEAD><BODY><P>=date(min(date,'MM/DD/YYYY')</P></BODY></HTML> Wed, 05 Apr 2017 10:00:02 GMT stonecold111 2017-04-05T10:00:02Z text object https://community.qlik.com/t5/QlikView/text-object/m-p/1345441#M846516 <HTML><HEAD></HEAD><BODY><P>In a text object iam trying to get the min date for which iam writing the below expression </P><P></P><P></P><P>Min(Date) ...and the output is not in the date format .....it shows someting like41034</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/text-object/m-p/1345441#M846516 smilingjohn 2020-11-25T16:16:04Z Re: text object https://community.qlik.com/t5/QlikView/text-object/m-p/1345442#M846517 <HTML><HEAD></HEAD><BODY><P>=Date(Min(Date))</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P></BODY></HTML> Wed, 05 Apr 2017 09:44:27 GMT https://community.qlik.com/t5/QlikView/text-object/m-p/1345442#M846517 MK_QSL 2017-04-05T09:44:27Z Re: text object https://community.qlik.com/t5/QlikView/text-object/m-p/1345443#M846518 <HTML><HEAD></HEAD><BODY><P>=date(min(date,'MM/DD/YYYY')</P></BODY></HTML> Wed, 05 Apr 2017 10:00:02 GMT https://community.qlik.com/t5/QlikView/text-object/m-p/1345443#M846518 stonecold111 2017-04-05T10:00:02Z