topic Re: Load date filed in QlikView https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661363#M1075038 <HTML><HEAD></HEAD><BODY><P>Hello Jonathan,</P><P></P><P>It works.. Thank you</P></BODY></HTML> Mon, 28 Jul 2014 06:10:19 GMT 2014-07-28T06:10:19Z Load date filed https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661361#M1075036 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table which contains datetime column (ex: 2014-07-18 10:00:00) say XXX.</P><P>I want to load this data into QV document as date only.</P><P>So in Load script I am using Date(XXX) as Xdate.</P><P>When i load the listbox with this field I am seeing the same value '07/18/2014', for number of rows of data.</P><P>I would like to know why is it like this instead of showing only once.</P><P></P><P>PFA the data file and load script I am using.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 28 Jul 2014 05:37:29 GMT https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661361#M1075036 2014-07-28T05:37:29Z Re: Load date filed https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661362#M1075037 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use this in the LOAD statement to strip out the time component:</P><P></P><P>LOAD ....</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Floor(myDateField)) As Date,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Mon, 28 Jul 2014 05:41:17 GMT https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661362#M1075037 jonathandienst 2014-07-28T05:41:17Z Re: Load date filed https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661363#M1075038 <HTML><HEAD></HEAD><BODY><P>Hello Jonathan,</P><P></P><P>It works.. Thank you</P></BODY></HTML> Mon, 28 Jul 2014 06:10:19 GMT https://community.qlik.com/t5/QlikView/Load-date-filed/m-p/661363#M1075038 2014-07-28T06:10:19Z