First Published Date

ces55739's Avatar


29 Jul, 2014 03:12 PM


I am wondering if there is a good way to get the first date a page is published. I know there is a last-published-on date. However, that variable will be updated when you republish.

Any thoughts on this issue?

  1. 1 Posted by Ryan Griffith on 29 Jul, 2014 04:47 PM

    Ryan Griffith's Avatar


    Aside from possibly using the created on date, the only way I can think of would be to obtain the asset's publish audits and find the first occurrence. This would be done using either Web Services or querying the database directly.

    One issue; however, is if the audit trail is cleared by the Optimize Database Tool, your results may be inaccurate.

    Please let me know if you have any questions.


  2. 2 Posted by ces55739 on 30 Jul, 2014 01:09 PM

    ces55739's Avatar

    Thanks a ton Ryan! I appreciate all the help you have given.

    Thats a bummer you can't get the first published date reliably. I think we are going to try to add a user entered date field on each page as a substitute.

  3. ces55739 closed this discussion on 30 Jul, 2014 01:09 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac