[SalesForce] Time field based on TimeZone

Is Salesforce time field dependant on timezone. Is the time field value change based on TimeZone.

Best Answer

The Time field type was created specifically to have a field that would be a time value independent of date. If your business hours are 08:00 - 18:00, regardless of the date, let's say, this is the purpose of this field. As the help states it is used "for time management, event planning, and project management."

For times that are time-zone dependent you can use the DateTime field instead. In that instance, you'll get a time that reflects the time zone of the user in accessing the field.

If you think about it, this makes sense. Without a date, it is impossible to be completely accurate about time zone conversion. Different parts of the world switch between summer and winter time. The ones that do, change at different times of the year. And some places do not change time during Winter and Summer.

Let's get concrete.

What is the time difference between London and New York? You might say 5 hours. And today 2 March, 2019, you would be correct. The UK is UTC +00:00, and New York is UTC -05:00.

But on 10 of March, the US moves to daylight saving time. The US will "Spring ahead" and New York will then move to UTC -04:00, but the UK (like most of the rest of Europe) will not change time. Meaning now there is a 4 hour difference between London and New York. Let me tell you, living in the UK, this wreaks havoc on my calendar as suddenly all my meetings with the US move an hour earlier. Argh!

For 3 weeks, just long enough to adjust, we remain in this strange 4 hour time difference temporary holding pattern until finally all us in Europe move to Summer time on 31 March. Havoc again ensues as we all go back to our regularly scheduled 5 hours difference with the UK moving to British Summer Time (UTC +01:00).

So a time field that exists independent of date would, by definition, be impossible to keep sync'd with time zones, until such time as the political will exists to end the silly time zone hopscotch that we're all subjected to. But that day is not today.

Related Topic