Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Try concatenated the values, first date, after timestamp:
= lastworkdate(timestamp(now()), 3) & ' ' & timestamp(now(), 'hh:mm:ss')
Hi
Try concatenated the values, first date, after timestamp:
= lastworkdate(timestamp(now()), 3) & ' ' & timestamp(now(), 'hh:mm:ss')
Hi Eduardo!!
That's perfect.
It's work fine now.
A question dude a knwon name: Where are you from?
Regards,
Rodrigo.
Hi,
I'm from Curitiba/PR Brazil
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.