Date and time of opening in coloumn

Question

Hello,

A simple question: there is a document library in sharepoint 2010, i need a coloumn, where will be date and time of last opening. User opens a document, date and time is writing to coloumn, like this.

How can I do this?

Answer 1

Check this article. Seems that you can achieve this my audit settings

http://www.fivenumber.com/sharepoint-document-counter-counts-the-document-downloads/

---

Regards,

Milan Chauhan

LinkedIn | Twitter | Blog | Email

Answer 2

The link mentioned by Milan will help you. But I think as you need to copy this value to a column, I would suggest using a Timer job which runs every 10 mins or so and updates all the documents "Lst Opened Field". This timer job can read from the audit logs.

Of course you would have to turn on the Audit settings on the document.

---

Varun Malhotra
=================
If my post solves your problem could you mark the post as Answered or Vote As Helpful if my post has been helpful for you.

Answer 3

For better understanding: I need a timestamp of download inside word .docx document. Someone suggested me a scheme: a coloumn, which stores the time, implementing to word document. When I open\download a document, event handler updates the value in word. So, I need to get time of opening somehow.