2 Replies Latest reply: Jun 25, 2013 11:19 AM by Friedrich Hofmann RSS

    Querying an SQL_Server database - strange results?

    Friedrich Hofmann

      Hi,

       

      I am querying a database with personell data. I want to draw out check-in data and find out whether, on any Saturday, more than, say, a dozen people checked in.

      There is a field in the table I am querying holding a date - The format, according to the helpdesk and the documentation I have, is YYYYMMDD.

      That should be easy enough to work with, no? Well, it seemingly does not correspond to the date format QlikView is expecting - when i select the value 20130601 from that field - the 1st of June, a Saturday when I know we had a workday, QlikView tells me it was a Sunday. Strange as that is, it gets even better - when I select 20130531, QlikView also tells me it was a Sunday.

       

      Can you think of a reason for this - and, more importantly, how I might be able to fix it?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler