Does lastworkdate() function works on timestamps or only dates

Fri, 29 Jul 2011 04:54:46 GMT

Hi all,

I am using Qlikview 9 SR5,

I have a doubt regarding lastworkdate() function.I am applying lastworkdate() for timestamps but its giving me null value.

Does it work only on dates.

For example:

lastworkdate('01-07-2011',2) gives me 04-07-2011 but

lastworkdate('01-07-2011 12:39:22',2) gives me NULL value

Require someone's help.

Thanks & Regards

Amay

Re: Does lastworkdate() function works on timestamps or only dates

Fri, 29 Jul 2011 12:06:32 GMT

it should be work with date and timestamp

i tried in a textbox

=LastWorkDate(Timestamp(now()),2)

it gives me 01.08.2011

or you can try

lastworkdate(date(yourtimestamp),2)