Discussion board where members can get started with QlikView.
I'm using lastworkday function but it does not work ok with time stamp.
I want to know the date with time from here 3 days in future.
=timestamp(lastworkdate (timestamp(now()), 3))
It's 15h30 in Portugal.
So.... the expression should be 15-07-2011 15:30:00
But... the expression returns 15-07-2011 00:00:00
Thanks for your help.
Go to Solution.
Try concatenated the values, first date, after timestamp:
= lastworkdate(timestamp(now()), 3) & ' ' & timestamp(now(), 'hh:mm:ss')
It's work fine now.
A question dude a knwon name: Where are you from?
I'm from Curitiba/PR Brazil
Ah que bacana!
Sou de São Paulo... mas moro em Portugal há 3 anos e meio.