718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

We’ve already covered some basic truths about CRM 2011 date and time. In this post, we’ll focus on how to avoid date-only fields from showing different dates in different time zones.


A common problem that arises unexpectedly for many CRM users is when a date-only field shows a different date for users in different time zones. When this happens, it is usually because CRM sets the default time of the date-only field to midnight and even though you specify “date only”, CRM stores a full date/time value. So, say a date is set for 10/1/2012 at 12 AM by a user in New York City. For users in Chicago the date translates into 9/30/2012 11PM. Therefore, when shown as date-only it will show a different day.

One simple way to prevent this from happening is to add some JavaScript that will update any date-only date values to be set to some other hour like 8AM or noon instead of 12AM/midnight.

In this example, we have a field “Date Event Confirmed” (schema name “po_dateeventconfirmed”). To make sure the time for this field is set to noon, we can set the OnChange event for the field to call the setSendEventNotice() function which in turn calls setDateTime() to do the work of setting the date/time values. Here’s what happens.

  1. When the value in “Date Event Confirmed” changes, it triggers setSendEventNotice()
  2. Within setSendEventNotice(), it calls setDateTime() to set the value of the field “po_dateeventconfirmed” specifying 8 as the hour and 30 as the minutes.
  3. Within setSendEventNotice(), it then resets the value of the field to 12 PM/noon.
  4. Note: You’ll notice that if the value of the field is originally blank, it uses the current date and adjusts the time accordingly; if the value of the field has already been set, it will use the existing date but only change the hour and minutes.

Here’s the code:

JavaScript for fixing CRM 2011 date and time

One big advantage of using generic, re-usable Javascript functions is that they can be developed as multi-functional procedures. So, in this case, the setDateTime() function can be utilized by any other field, which may pass it any other field name and hour/minute combination. If we were to create the following function that is triggered OnChange of a “Send Event Notification” date field (schema name “po_sendeventnotice”), it would set the time of that field to 8:30 AM.

Happy CRM’ing!

Avatar for JoeCRM


Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.