I want an understanding of time offset for text value

Soumyajit

I am trying to create a module where I need to add a text value in IST and the same will populate in PST and GMT timing.

I have created a module with DAY time dimension and with a list defining 00:00 hours to 23:00 hours and added 3 line items (IST, PST and GMT)

Now I have added a formula in GMT

IF ISNOTBLANK(IST) THEN OFFSET(IST, 0, BLANK) ELSE BLANK

but if I add any text in IST its not populating in GMT. The line items are text formatted.

I probably missed something. Please help

devrathahuja

Hi @Soumyajit ,
You can achieve this by a mapping between the hours list.

Create a hours list & have the mapping for GMT & PST timings-

For this example I've added it as a property but you should maintain these mappings in a SYS module.

In the final module you can them use firstnonblank: GMT mapping to get the required result

So here the text entered at 09:30 will be shown also at 04:00 in GMT & 09:00 in PST.

Hope this helps!