Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)