topic Differences in Interval() between 64- and 32-bit version? in QlikView

Differences in Interval() between 64- and 32-bit version?

Mon, 09 Jul 2012 21:43:50 GMT

So, I've been going a little crazy trying to figure this out, but I think I've finally narrowed it down.

I want to figure out the age of a record by getting the difference between today and the date the record was created. I used the following code as an expression in a crosstab table:

= Interval(Date(now(2), 'MM/dd/yyyy hh:mm') - Date#([UCO Open Date], 'MM/dd/yyyy hh:mm'),'dd')

On my 32-bit machine, which I use for development, this worked fine. So, I deployed it and later on noticed that all the Ages were "0". Eventually, I narrowed it down by brute force to the following code, which works on the 64-bit machine:

= Interval(Date(now(2), 'MM/dd/yyyy hh:mm') - Date([UCO Open Date], 'MM/dd/yyyy hh:mm'),'dd')

Notice: all I did was change Date#() to Date().

Now, I'd be happy with this, but the latter snippet does not work on a 32-bit machine. All the Ages become 0 when I try this on the 32-bit system. So, I'm a little baffled. Perhaps I'm doing something wrong, maybe I should move this into the script? If I had some way to test for the OS, I could switch between the two, and while that seems a little silly, it won't be the first time I have done such a thing.

Both versions on the machines are identical (other than the different -bit). This effect appears on the QV Accesspoint, as well, which is also 64-bit.

Any suggestions as to whether I'm dealing with a bug, or doing something wrong?

(I've attached the file in case anyone wants to have a look. This would be the Age column on the Unassigned Change Orders table on the Book of Work w/Change Orders tab)

Re: Differences in Interval() between 64- and 32-bit version?

jonathandienst — Tue, 10 Jul 2012 06:19:21 GMT

Perhaps you are overcomplicating the expression. Now() returns a date/time value. If [UCO Open Date] is also a date/time value, then

=Interval(Now(2) - [UCO Open Date], 'dd')

should work on both 32 and 64 bit machines.

No, I don;t know why the other expressions were uneven on 32 and 64 bit, but I don't think they are necessary.

Hope that helps

Jonathan

Re: Differences in Interval() between 64- and 32-bit version?

hic — Tue, 10 Jul 2012 17:00:44 GMT

When I look in your application, I can see that the [UCO Open Date] has not been interpreted as date. So you need to use an interpretation function: Date#([UCO Open Date], 'M/D/YYYY hh:mm').

Further, I suspect that the Now(2) is not well defined on a server: The "2" means "when the document is opened" and that is not necessarily the same as when the session is opened. But I have not verified this.

So I would suggest that you use the following expression:

= Interval(now(0) - Date#([UCO Open Date], 'M/D/YYYY hh:mm'),'dd')

HIC

Re: Differences in Interval() between 64- and 32-bit version?

Tue, 10 Jul 2012 19:06:19 GMT

Jonathan Dienst wrote:
Hi
Perhaps you are overcomplicating the expression. Now() returns a date/time value. If [UCO Open Date] is also a date/time value, then
=Interval(Now(2) - [UCO Open Date], 'dd')
should work on both 32 and 64 bit machines.
No, I don;t know why the other expressions were uneven on 32 and 64 bit, but I don't think they are necessary.
Hope that helps
Jonathan

Thanx for the response, Jonathan. This works on my 64-bit machine, but not on the 32. This is pretty much what I started with and the fact that I couldn't get this to work is what prompted me to bring in the Date functions to begin with.

Re: Differences in Interval() between 64- and 32-bit version?

Tue, 10 Jul 2012 19:10:24 GMT

Henric Cronström wrote:
When I look in your application, I can see that the [UCO Open Date] has not been interpreted as date. So you need to use an interpretation function: Date#([UCO Open Date], 'M/D/YYYY hh:mm').
Further, I suspect that the Now(2) is not well defined on a server: The "2" means "when the document is opened" and that is not necessarily the same as when the session is opened. But I have not verified this.
So I would suggest that you use the following expression:
= Interval(now(0) - Date#([UCO Open Date], 'M/D/YYYY hh:mm'),'dd')
HIC

Thanx for the response, Henric,

This works on my 32-bit system but not on the 64.

I'm thinking that maybe I should just go back to my datasource and calculate the date there. I'm really quite baffled.

Thanx again for trying, guys.