Date-time to be shown in label with a different time-zone. Ideas?

Previous Member

Hi everybody,

I would like to show in a label the current date (@date) and the current time minus 1 hour.

That's why Board server is running in italian time, I would like to show in the label the UK-time.

I've done it with a very complex nexel

Is there someone with a smarter idea?

Thank you,

regards,

Edoardo

Tags: dates and time datetime time calculation timezone

Find more posts tagged with

Usage

Accepted answers

All comments

Nicolas CHIGROS

Not a smart idea , but maybe use viewer object on a Url like this https://time.is/just

Zoltán Csorba

Hi Edoardo,

Nexel is very powerful and can be a solution for this need.

You can also try to:

1. create a text cube, that is structured by a dummy entity.

2. dataflow @Time to this cube

3. extract this cube

4. create an ascii reader from the extract to the cube created in step 1 and apply ETL, that is reducing the hour value by 1

5. chain these actions into a procedure with a screen refresh at the end and your done

Nicolas CHIGROS

Hi,

I'm wondering : what will happen if you have 60+ users opening this screen at about the same time with that solution? Won't it queue up the procedure? And therefor users be stuck a few second before data are refreshed?

Moreover, Date won't match around midnight

Regards,