topic Qlik Sense Date in QlikView https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929146#M649770 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P>it's me again.</P><P></P><P>I got a SQL Database with 15 timestamps (from 01.03.2005 hh:mm:ss.ffff to 01.04.2005 hh:mm:ss.ffff).</P><P>When i check the dates in my SQL viewer (SQLStudio) the timestamps are correct, but as soon as i try to load the data, the dates a getting converted to "09.24.2015 hh:mm:ss.ffff" (todays date).</P><P>The other weird thing is that as soon as "today" (in the new timestamp) would it, Qlik starts again with the 24th of September 2015.</P><P></P><P>Can anyone give me a hint what it could be?</P><P><BR />Regards,</P><P>Chris</P><P></P><P>P.S.: I'm using Qlik Sense Desktop 2.1.1 (newest version at the moment)</P></BODY></HTML> Thu, 24 Sep 2015 07:19:13 GMT igdrazil 2015-09-24T07:19:13Z Qlik Sense Date https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929146#M649770 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P>it's me again.</P><P></P><P>I got a SQL Database with 15 timestamps (from 01.03.2005 hh:mm:ss.ffff to 01.04.2005 hh:mm:ss.ffff).</P><P>When i check the dates in my SQL viewer (SQLStudio) the timestamps are correct, but as soon as i try to load the data, the dates a getting converted to "09.24.2015 hh:mm:ss.ffff" (todays date).</P><P>The other weird thing is that as soon as "today" (in the new timestamp) would it, Qlik starts again with the 24th of September 2015.</P><P></P><P>Can anyone give me a hint what it could be?</P><P><BR />Regards,</P><P>Chris</P><P></P><P>P.S.: I'm using Qlik Sense Desktop 2.1.1 (newest version at the moment)</P></BODY></HTML> Thu, 24 Sep 2015 07:19:13 GMT https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929146#M649770 igdrazil 2015-09-24T07:19:13Z Re: Qlik Sense Date https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929147#M649771 <HTML><HEAD></HEAD><BODY><P>Please provide sample data</P></BODY></HTML> Fri, 25 Sep 2015 07:23:18 GMT https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929147#M649771 sasiparupudi1 2015-09-25T07:23:18Z Re: Qlik Sense Date https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929148#M649772 <HTML><HEAD></HEAD><BODY><P>Fixed the problem,</P><P>we had a problem with the Timestamp field in the database, where it was formatted wrong (german time-stamp format instead of US)</P></BODY></HTML> Mon, 28 Sep 2015 06:11:59 GMT https://community.qlik.com/t5/QlikView/Qlik-Sense-Date/m-p/929148#M649772 igdrazil 2015-09-28T06:11:59Z