followupby field in incident RRS feed

  • Question

  • 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


All replies

  • 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
  • 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
  • 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
  • Oh I see...I forgot there are filtered views...Thanks David Jennaway.
    Wednesday, May 16, 2012 6:04 AM