locked
CreatedOn is later than ModifiedOn RRS feed

  • Question

  • Hi, I found that some of my records is having a weird problem that
    Account ID   Created On                  Modified On
    CO-1105001 05/01/2010 00:46 AM   05/01/2010 00:43 AM

    May I know under what situation this could happen?

    Thursday, January 6, 2011 2:38 AM

Answers

  • Probably not relevant, but are the clocks on your servers sync'd?

     

    I have no authority or information on this, but they could be using two different ways of entering dates.

     

     

    • Marked as answer by Henry Tan YH Thursday, January 6, 2011 8:28 AM
    Thursday, January 6, 2011 4:59 AM

All replies

  • Well your example has the creation date earlier but I expect you just wrote it the wrong way around.

    In the case of 1 minute, I'm guessing on the creation of the record the back end was systematically populating the fields and happened to populate the modified date first and in the fractions of a second before it populated the creation date the minute hand ticked over.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet http://www.twitter.com/leontribe

     


    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Thursday, January 6, 2011 3:19 AM
    Thursday, January 6, 2011 3:19 AM
  • Hi leon,
    Yeah I have modified and reverse the creation/modification datetime. Some of it doesn't take 1 minutes different. I have about 50 records with 2-3 minutes difference in creation and modification datetime.

    Thursday, January 6, 2011 3:23 AM
  • Probably not relevant, but are the clocks on your servers sync'd?

     

    I have no authority or information on this, but they could be using two different ways of entering dates.

     

     

    • Marked as answer by Henry Tan YH Thursday, January 6, 2011 8:28 AM
    Thursday, January 6, 2011 4:59 AM
  • Yes you are right!

    i found the root cause!

    CRM Web and Workflow Async Server time are not in Sync!

    Shouldn't CRM update the creation / modification time stamp base on Database server?

    Thursday, January 6, 2011 8:28 AM