Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having an issue comparing dates from a Sql Server database to pull most recent inserted and changed records.
Within my script I set my most recent updated/inserted date to the maximum value from the qvd. That value is 41569.498310185 which comes from the date 2013-10-22 11:57:34.000.
I then change a record on the sql server database to have a updated/inserted date two hours ahead of the previous max date. so it's value is 2013-10-22 13:57:34.000. I run the script again with the WHERE clause comparing my database date greater than or equal to the maximum value from the qvd. WHERE MySqlDate >= $(vLastExecTime). I keep setting the database date a little higher and it still doesn't pick it up. I end up with a date two days in advance. 2013-10-24 18:57:34.000 then it meets the condition and updates the qvd.
I assume there is some sort of date translation I need to do to the MySqlDate on the Where clause?
Thanks
I found the answer to the problem. According to this post it is because of the different date starting points that QlikView and Sql Server use that the numerical date value is calculated on.
Two days in advance ?! So you need a "vMin_time" and a "vMax_time".
Where MySqlDate >= $(vMin_time) and MySqlDate <= $(vMax_time)
Why would I need a max time? shouldn't I be able to use a Min Date/time and check for greater than or equal to? I want all records that that meet that criteria whether it's just a second greater but Qlikview doesn't seem to be that accurate with the date comparison in some way.
I found the answer to the problem. According to this post it is because of the different date starting points that QlikView and Sql Server use that the numerical date value is calculated on.