Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

LASTWORKDAY with TimeStamp

Hi guys,

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.

Exemple:

=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

Why??????

Thanks for your help.

Regards,

Rodrigo.

1 Solution

Accepted Solutions
Not applicable

LASTWORKDAY with TimeStamp

Hi

Try concatenated the values, first date, after timestamp:

= lastworkdate(timestamp(now()), 3) & ' ' & timestamp(now(), 'hh:mm:ss')

4 Replies
Not applicable

LASTWORKDAY with TimeStamp

Hi

Try concatenated the values, first date, after timestamp:

= lastworkdate(timestamp(now()), 3) & ' ' & timestamp(now(), 'hh:mm:ss')

Not applicable

LASTWORKDAY with TimeStamp

Hi Eduardo!!

That's perfect.

It's work fine now.

A question dude a knwon name: Where are you from?

Regards,

Rodrigo.

Not applicable

LASTWORKDAY with TimeStamp

Hi,

I'm from Curitiba/PR Brazil

Not applicable

LASTWORKDAY with TimeStamp

Ah que bacana!

Bela cidade...

Sou de São Paulo... mas moro em Portugal há 3 anos e meio.

Mantemos contato!

Um abraço,

Rodrigo.

Community Browser