topic LASTWORKDAY with TimeStamp in QlikView https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275387#M1190632 <HTML><HEAD></HEAD><BODY><P>Ah que bacana!</P><P>Bela cidade...</P><P></P><P>Sou de São Paulo... mas moro em Portugal há 3 anos e meio.</P><P></P><P>Mantemos contato!</P><P></P><P>Um abraço,</P><P>Rodrigo.</P></BODY></HTML> Tue, 12 Jul 2011 17:12:50 GMT 2011-07-12T17:12:50Z LASTWORKDAY with TimeStamp https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275383#M1190622 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I'm using lastworkday function but it does not work ok with time stamp.</P><P>I want to know the date with time from here 3 days in future.</P><P></P><P>Exemple:</P><P>=timestamp(lastworkdate (timestamp(now()), 3))</P><P></P><P>It's 15h30 in Portugal.</P><P>So.... the expression should be 15-07-2011 15:30:00</P><P>But... the expression returns 15-07-2011 00:00:00</P><P></P><P>Why??????</P><P></P><P>Thanks for your help.</P><P>Regards,</P><P>Rodrigo.</P></BODY></HTML> Tue, 12 Jul 2011 14:52:20 GMT https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275383#M1190622 2011-07-12T14:52:20Z LASTWORKDAY with TimeStamp https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275384#M1190627 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try concatenated the values, first date, after timestamp:</P><P></P><P>= lastworkdate(timestamp(now()), 3) &amp; ' ' &amp; timestamp(now(), 'hh:mm:ss')</P></BODY></HTML> Tue, 12 Jul 2011 15:20:25 GMT https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275384#M1190627 2011-07-12T15:20:25Z LASTWORKDAY with TimeStamp https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275385#M1190629 <HTML><HEAD></HEAD><BODY><P> Hi Eduardo!!</P><P></P><P>That's perfect.</P><P>It's work fine now.</P><P></P><P>A question dude a knwon name: Where are you from?</P><P></P><P>Regards,</P><P>Rodrigo.</P></BODY></HTML> Tue, 12 Jul 2011 15:37:05 GMT https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275385#M1190629 2011-07-12T15:37:05Z LASTWORKDAY with TimeStamp https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275386#M1190630 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm from Curitiba/PR Brazil</P></BODY></HTML> Tue, 12 Jul 2011 16:17:54 GMT https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275386#M1190630 2011-07-12T16:17:54Z LASTWORKDAY with TimeStamp https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275387#M1190632 <HTML><HEAD></HEAD><BODY><P>Ah que bacana!</P><P>Bela cidade...</P><P></P><P>Sou de São Paulo... mas moro em Portugal há 3 anos e meio.</P><P></P><P>Mantemos contato!</P><P></P><P>Um abraço,</P><P>Rodrigo.</P></BODY></HTML> Tue, 12 Jul 2011 17:12:50 GMT https://community.qlik.com/t5/QlikView/LASTWORKDAY-with-TimeStamp/m-p/275387#M1190632 2011-07-12T17:12:50Z