Given a particular date/time in a particular TimeZone, is there a way to calculate the difference in hours, on any particular day, between this date/time and a different Time Zone? (ie taking all TimeZone info into account including DST).
The reason I’m doing this is because I’m capturing a date/time via a web application (global) and need to calculate the precise equivalent date/time in different Time Zones.
I am not using cookie based Locale info for diverse and historic reasons by the way.
Therefore, I am capturing the date/time but storing it incorrectly in the local timezone (ie since it’s a web app and the web server’s time zone is assumed), but I know the TimeZone of the user that inputed the date/time.
So effectively, I want to calculate the difference between two places in the world at any moment in time, so I can programmatically create an offset.
Since I am capturing a StartDateTime using a web form, the server assumes the user time zone is the server time zone, which it is not in most cases (it’s a global app).
with @TimeMerge, I was able to extract just the the absolute date and time separately and merge them with whatever TimeZone I want in order to get the actual time stored correctly in the date/time item.