CRM Date Time issue RRS feed

  • Question

  • Hi

    CRM Date is shown a day behind in DB server.

    I used
    Select dbo.fn_UTCToLocalTime(<Your DB Field>) ...
    instead of  Select <Your DB Field>  for querying.
    But its returning null value.
    Please help...



    • Edited by rittu123 Monday, July 26, 2010 11:01 AM
    Monday, July 26, 2010 10:53 AM


  • I have same problem.  Function dbo.fn_UTCToLocalTime always returns null.



    dbo.fn_FindUserGuid() returns null becouse query is not runing by priviledged user with user role of CRMReaderRole or there is CRM account for that user.


    CRM account contain user time zone which is requried to correct calculate datatime from utc.




    Wednesday, August 25, 2010 1:33 AM

All replies