Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
  • 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.
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
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 will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

569 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