Solved

Having issue with reports date after day light savings

Posted on 2008-10-22
6
230 Views
Last Modified: 2008-11-10
Hi

 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  (http://support.microsoft.com/kb/948155)
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

Thanks
Rakesh AGarwal
0
Comment
Question by:rakeshAgarwal
  • 3
  • 3
6 Comments
 
LVL 15

Expert Comment

by:WilyGuy
Comment Utility
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?
0
 
LVL 11

Author Comment

by:rakeshAgarwal
Comment Utility
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

Thanks
Regards
Rakesh Agarwal
0
 
LVL 15

Expert Comment

by:WilyGuy
Comment Utility
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.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 15

Expert Comment

by:WilyGuy
Comment Utility
Is the same thing happening with ootb reports?
0
 
LVL 11

Author Comment

by:rakeshAgarwal
Comment Utility
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;
0
 
LVL 11

Accepted Solution

by:
rakeshAgarwal earned 0 total points
Comment Utility
I have resolved the issue

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

Regrads
Rakesh agarwal
www.dynamicsexchange.com
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now