Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Does lastworkdate() function works on timestamps or only dates

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

1 Reply
Not applicable
Author

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)