Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
followupby field in incident RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    I found that theere a field call "followupby" in the incident entity, but I feel confuse of its properties...Because I found that, when I set the followupBy as "2012-05-15", then it will record as "2012-05-14" in the database...but it show correct as "2012-05-15" in the interface....may I ask if that is a bug or default setting of the field please?

    Many thanks.

    Tuesday, May 15, 2012 7:25 AM

Answers

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    The difference in the time/date is due to the user's timezone settings. So, a user may see 2012-05-15 00:00, but this would be converted to UTC for storage in the database, so it might be stored as 2012-05-14 23:00, for example. This behaviour will be the same for all CRM DateTime fields (note that all DateTime fields are stored as a DateTime, even if configured to only display the date component)

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Tuesday, May 15, 2012 7:45 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi DavidJennaway, thanks for the reply.

    May I ask that, is that mean I always have to -1 Day to compare with the DateTime Field in CRM ?

    Many thanks

    Tuesday, May 15, 2012 8:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    How are you performing the comparison ?

    If this is in SQL, then it is easiest to use the filtered views (e.g. filteredincident). These will apply the timezone of your CRM user to any datetime field, and so will return the same value as that user would see in CRM

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Tuesday, May 15, 2012 3:20 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Oh I see...I forgot there are filtered views...Thanks David Jennaway.
    Wednesday, May 16, 2012 6:04 AM