Having issue with reports date after day light savings

Posted on 2008-10-22
Medium Priority
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  (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

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.
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

771 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