I have 2 var’s im working with,
1 is the time in EST HH:mm tt [ input value example : 5:00 pm ]
the second is the gmt +/- of the client [ input value example : -2:00 ]
ignoring daylight saving issues, the goal is to take the time and display it in the clients local time.
for example , if i have a project starting at 6pm EST, and a client in a timezone of -1 gmt,
EST is -5gmt so i know the local time is 2pm for the client.
here is formula i use so far for int32 ( did this as a test )
[Assign] X = -5 (EST var )
[Assign] Y = -1 ( Local time )
[Assign] Result = math.abs(x - (y))
Result = z - Result
Result = z + result
This seems to return the correct values, but its in int32. I cant seem to get it working with dateTime.
problem is some of the meetings are like, 16:15 etc, so int wont cut it. Any suggestions ?