Solved

Dynamics CRM Dates

Posted on 2010-08-20
3
819 Views
Last Modified: 2013-11-24
When you put a date like 8/12/10 into a CRM window, it might save as 8/12/10 5:00am because the guy who did it lives in the Eastern Timezone, 5 hours off GMT).  Then when someone in the Pacific timezone pulls up this record, it has a 5-hour offset, it computes for their local time 8 hours different (because they are 8 hours off GMT).  So it takes 8/12/10 5am and computes 8/11/10 9pm, and then displays "8/11/10", a whole day different.  Is this a bug?  How can I get around this problem as it is a really big problem.
0
Comment
Question by:GaryRasmussen
  • 2
3 Comments
 
LVL 3

Expert Comment

by:59cal
ID: 33489545
Hi,

See this blog. Its as designed

http://microsoft-crm.spaces.live.com/blog/cns!A2586C4AB938C065!1253.entry

The only way round this i can think of is to set all the users time-zone settings to be the same (i.e. Pacific Time)
0
 
LVL 1

Accepted Solution

by:
GaryRasmussen earned 0 total points
ID: 33489607
Thanks,

I read several blogs like this before posting.

I realize this is by design but I am flabbergasted by this design.  Why would you want users talking to customers on the phone and telling them that they were a day late on their mortgage payment when they were not?

Using time zones like this makes sense but there are lots of times when we not only don't care about the time, it gets in the way or in this case, skews the data.  If I enter somebodys birthday in CRM.  I don't want the date to be a day off just because of what time it was and what time zone I happened to be in when I entered it.  Really frustrating.

What CRM needs then is another data type that ignores time all together.  That would be a better design.
0
 
LVL 1

Author Closing Comment

by:GaryRasmussen
ID: 35321800
Unfortunately just a bad design IMO
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question