Time Zone problems

[g.orloff]

I have a problem with the time zone for New York (USA), because when I use the code with a negative number -4 for the time difference from Norway ((#DUH#-4)%24):#DmZ# it does not show the correct time when it comes to midnight. As long as you put in a positive number it all works very well on any other time zone that’s ahead of Norway. Can anybody please tell me why and help me with solving this issue?

[tom.vannes]

Have a look at this thread:

Changing timezone

Maybe that will help…

[petruuccios]

@g.orloff

when I use the code with a negative number -4 for the time difference from Norway ((#DUH#-4)%24):#DmZ# it does not show the correct time when it comes to midnight.

I think you need to add 24 to any negative time zone offset for the formula to work both directions

How do I display the Central Time Zone no matter where I am in the world?

Hello I think it is not so difficult. We solved here the zero crossing on multiple purposes, being it a day in year or seconds minutes hours before and after current one. The key is modulo and not using negative but positive difference in the shifted period like ((#DUH#+18)%24). Think of it like adding the time it would be there at UTC midnight, then calculating the reminder of division by the day period (24h).

[g.orloff]

Thanks again for answering my questions, I hope I am not bothering you to much. Great to see all the positivity in this forum .

[g.orloff]

It worked great, just had to ad +20 instead of +18 from the time in Norway, will check it later, so thank you again.

[icrltd4]

Welcome to the Community, where you’ve already found out that there’s lots to learn and plenty of helpful people too

[g.orloff]

Just great, love it