Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
igdrazil
Creator III
Creator 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)

1 Solution

Accepted Solutions
igdrazil
Creator III
Creator III
Author

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)

View solution in original post

2 Replies
sasiparupudi1
Master III
Master III

Please provide sample data

igdrazil
Creator III
Creator III
Author

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)