LASTWORKDAY with TimeStamp

[#1]

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.

[#2 · Accepted solution]

Hi

Try concatenated the values, first date, after timestamp:

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

[#3]

Hi Eduardo!!

That's perfect.

It's work fine now.

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

Regards,

Rodrigo.

[#4]

Hi,

I'm from Curitiba/PR Brazil

[#5]

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.