At Convergence 2014, the tipsters participated in some “Ask the MVP” sessions. There were many great questions, but one question kept coming up time and time again, no matter whether the session was for administrators or developers. That’s right: how to deal with timezones when date-only field is used. Since our tipping truck is a fast moving machine we don’t have time (ba dum tsh) for a full explanation so here the abridged version:
Problem: user saves value in date-only field but since database field does contain time, another user may see a different date value in their timezone.
Solution: plugin that sets time portion of the field to 10:59AM in UTC.
For a mildly entertaining but much longer full explanation see How to correctly record the end of the world in CRM by yours truly.