Querying an SQL_Server database - strange results?
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?