Updating createdon attribute RRS feed

  • Question




    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?





    Tuesday, December 2, 2008 5:40 PM


All replies

  • 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
  • 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.






    Wednesday, December 3, 2008 10:11 AM
  • I understand,  you can check the SDK for suggestions or some in here might be aware of an unsupported method for making the change.



    Best of Luck


    Wednesday, December 3, 2008 2:08 PM