topic difference between Date and Date# function in QlikView https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946921#M981533 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>What is the difference between Date and Date# function?</P></BODY></HTML> Tue, 18 Aug 2015 14:24:33 GMT qlikviewwizard 2015-08-18T14:24:33Z difference between Date and Date# function https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946921#M981533 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>What is the difference between Date and Date# function?</P></BODY></HTML> Tue, 18 Aug 2015 14:24:33 GMT https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946921#M981533 qlikviewwizard 2015-08-18T14:24:33Z Re: difference between Date and Date# function https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946922#M981534 <HTML><HEAD></HEAD><BODY><P>This post by HIC should clarify things.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P>Also: <A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Tue, 18 Aug 2015 14:28:31 GMT https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946922#M981534 b_garside 2015-08-18T14:28:31Z Re: difference between Date and Date# function https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946923#M981535 <HTML><HEAD></HEAD><BODY><P>did you read this?</P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Tue, 18 Aug 2015 14:29:22 GMT https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946923#M981535 maxgro 2015-08-18T14:29:22Z Re: difference between Date and Date# function https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946924#M981536 <HTML><HEAD></HEAD><BODY><P>Same as between Num() and Num#(). One does formatting for ouput, the other tries to convert a string into a numerical date representation. </P><P></P><P>See also here: <A href="https://community.qlik.com/thread/176872">What is the difference between Num and Num# function?</A></P><P></P><P>Peter</P></BODY></HTML> Tue, 18 Aug 2015 14:29:28 GMT https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946924#M981536 Peter_Cammaert 2015-08-18T14:29:28Z Re: difference between Date and Date# function https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946925#M981537 <HTML><HEAD></HEAD><BODY><P>The date# function formats any given string which holds a date to a vaild dateformat</P><P>e.g. date#('2015-08-18','YYYY-MM-DD')</P><P>The date function formats a valid date field to your liking</P><P>date('2015-08-18','MM/YY') will Show 08/15</P></BODY></HTML> Tue, 18 Aug 2015 14:30:12 GMT https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946925#M981537 Anonymous 2015-08-18T14:30:12Z Re: difference between Date and Date# function https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946926#M981538 <HTML><HEAD></HEAD><BODY><P>Hi Qlik,</P><P></P><P>please check below post by henric:</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4002">The Date Function</A></P><P></P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Tue, 18 Aug 2015 14:53:00 GMT https://community.qlik.com/t5/QlikView/difference-between-Date-and-Date-function/m-p/946926#M981538 Anonymous 2015-08-18T14:53:00Z