Having issue with reports date after day light savings

Posted on 2008-10-22
Last Modified: 2008-11-10

 I created a report for my client. All was going well  till day light savings were applied.  Date shown on the form is  Todays date  but the date shown in the database  or report is  yesterdays  date

What I have done.

1. I checked the database and database is also stroring wrong dates
2. On  the form its  showing right date and time ( I am confused )
3. I have applied the hotfix  (
4. My client is in australian time zone
5. When we write report do we need to take care of time zone  if yes how

Rakesh AGarwal
Question by:rakeshAgarwal
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 15

Expert Comment

ID: 22775042
So the times are wrong in the CRM Database?
Showing correctly on the form, but wrong on the report?

And you applied the hotfix to server and all clients (Outlook)?
It says on the hotfix that "The installation of this hotfix does not correct existing data. Therefore, any date values and time values that occur in the standard portion of the year are adjusted by nn hours, where  nn is the user's time zone offset from GMT. To correct this, you must manually correct any date values and time values that are affected."

Was this existing data?
LVL 11

Author Comment

ID: 22775500
1. On the CRM form data  is perfect
 2.  In database "Createdon" is perfect  but other dates  have issues
3.  Report picks  data from the database so  what ever is in database  it picks up that  ( For mscrm  time zone do we need to put  some special formating )
4. All my clients  are on australian time zone
5. I have checked with new   record also  same issue
6.  Custom attribute new_  or old attribute like estimated cose  date  have same issue  only  Created on and modified on are stored perfectly.
7. I have also checked stored  procedures whcih  I can use .  but no luck

Rakesh Agarwal
LVL 15

Expert Comment

ID: 22784701
I think you are likely best off with a Microsoft Ticket.  Because of the newness of the product and the hotfix, there is a good likelihood that it will not be charged.
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

LVL 15

Expert Comment

ID: 22784709
Is the same thing happening with ootb reports?
LVL 11

Author Comment

ID: 22784931
Yes  I thought the same nut getting Microsoft support is horrible  :(   they really take long time.

 I will check and let you  know . Thanks
 Thanks  and regards
Rakesh Agarwal;
LVL 11

Accepted Solution

rakeshAgarwal earned 0 total points
ID: 22892283
I have resolved the issue

we restarted the server and it worked thanks wily for all help. thants amazinag solution

Rakesh agarwal

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

728 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