Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

igdrazil
Contributor III

Qlik Sense Date

Hi Community,

it's me again.

I got a SQL Database with 15 timestamps (from 01.03.2005 hh:mm:ss.ffff to 01.04.2005 hh:mm:ss.ffff).

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).

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.

Can anyone give me a hint what it could be?


Regards,

Chris

P.S.: I'm using Qlik Sense Desktop 2.1.1 (newest version at the moment)

Tags (1)
1 Solution

Accepted Solutions
igdrazil
Contributor III

Re: Qlik Sense Date

Fixed the problem,

we had a problem with the Timestamp field in the database, where it was formatted wrong (german time-stamp format instead of US)

2 Replies
sasiparupudi1
Honored Contributor III

Re: Qlik Sense Date

Please provide sample data

igdrazil
Contributor III

Re: Qlik Sense Date

Fixed the problem,

we had a problem with the Timestamp field in the database, where it was formatted wrong (german time-stamp format instead of US)