topic Re: Difference between dates in QlikView

Difference between dates

jduenyas — Tue, 27 Aug 2013 21:29:28 GMT

It must be very simple but I cannot get the result I am looking for:

How do I calculate a difference between dates?

And why this expression :

Day(Monthend(Today())) - Day(Today())

Returns nothing (error)

The expression Day(Monthend(Today())) correctly returns 31 which is an integer (for this month)

and the expression Day(Today()) correctly returns 27 which is an integer (for today 7/27/13)

But subtracting one from the other returns nothing.

I tried to convert them to numerical value Num(Day(Today()),'###') and Num(Day(Monthend(Today())) ,'###') but that did not work either.

Help?

Thanks

Re: Difference between dates

Sokkorn — Wed, 28 Aug 2013 03:48:44 GMT

Hi Josh,

Not sure you try this yet:

Interval(Monthend(Today()) - Today(),'d') or Floor(Monthend(Today()) - Today())

Regards,

Sokkorn

Re: Difference between dates

tresB — Wed, 28 Aug 2013 04:22:04 GMT

The Expression : =Day(Monthend(Today())) - Day(Today()) should work fine(working fine for me). Try that in a text object. May be you are having issue somewhere else.

Re: Difference between dates

dmohanty — Wed, 28 Aug 2013 04:28:45 GMT

Hi Josh,

The above expression will work both in Script and Text Object.

Let V1 = Today();

V2= Day(Monthend(Today())) - Day(Today())

Now V2 will result in 3.

Could you please reply more where and how you want to calculate so that we can help?

Re: Difference between dates

jduenyas — Wed, 28 Aug 2013 15:50:47 GMT

Thank you Sokkorn.

I am not sure if these are the only answers but your answers (both) returned the right result.

I must say though that after trying some more and enclosing the expression within parenthesis, it did work:

Day(Monthend(Today())) - Day(Today())

does not work

But

( Day(Monthend(Today())) - Day(Today()) )

does work.

Peculiar!

Once again , thank you.