1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Manipulating PublicationDate at database

Manipulating PublicationDate at database

2 posts, 0 answered
  1. Andre' Hazelwood
    Andre' Hazelwood avatar
    3 posts
    Registered:
    14 Oct 2005
    18 Feb 2010
    Link to this post
    I need to automate changing the publication date for some blog entries to some time in the future.  How is the Publication_Date value computed so I can change it from within another Stored Procedure? 

    For example, a Publication value of '1-6-2010 20:55:00'  is '5245670351427387904' in the sf_VrsTxtData table.  How do I move this to '2-1-2010 5:00:00' for example?

    Thanks for your help.

  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    19 Feb 2010
    Link to this post
    Hi Andre' Hazelwood,

    You can use the API to change the value of the Publication_Date. The Publication_Date is metakey and you can access it by using GetMetaData method of IContent object and set it by using SetMetaData method.

    All the best,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
2 posts, 0 answered