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
  • 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.
ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

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…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

770 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