Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Updating createdon attribute RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hi

     

    Anyone have a suggestions to how to update a number of activities that have an incorrect Date Created (createdon) attribute? As I understand it this attribute is read-only and that there exists an attribute overiddencreatedon that can be used when creating new records - this does not help me however with existing records.

     

    Is the only answer to use a SQL update and, if so, does anyone have any experience as to whether or not there are any ill effects?

     

    Thanks

     

     

    Tuesday, December 2, 2008 5:40 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Direct SQL updates to the database are not supported and may create problems for these fields since they are system set.  You could create a custom field and put the actual create date in that field.

     

    Tuesday, December 2, 2008 6:03 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Donna

     

    Thanks for the suggestion - that's certainly possible but my guess is it would require to a number of customisations and where currently Date Created is used for example in existing reports, views etc this might not be a complete solution. I take the point about changing the sql db directly (heaven help us!) but I can't believe that it is impossible to reset the createdon value by some other mechanism. It is only a database value after all.

     

    Regards

     

    Stuart

     

    Wednesday, December 3, 2008 10:11 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I understand,  you can check the SDK for suggestions or some in here might be aware of an unsupported method for making the change.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=82e632a7-faf9-41e0-8ec1-a2662aae9dfb&displaylang=en

     

    Best of Luck

     

    Wednesday, December 3, 2008 2:08 PM