

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please provide sample data


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
