Solved

creation date of document(sharepoint library)

Posted on 2010-09-05
9
966 Views
Last Modified: 2012-06-21
Hi,
 The document library contains a field created which gives you the document creation time. but if you upload the document it gives you the uploaded date as created. Is there away that i can get the document creation date.
My collegue suggested that i write vba code to get the file property .  please can you guys paste an example and help me.
0
Comment
Question by:Myworld
9 Comments
 
LVL 14

Expert Comment

by:RickEpnet
Comment Utility
I would put a form field for the document lib and then put in a date field. Set the current date as the default but his way when you upload files you can put in whatever date you want.
0
 

Author Comment

by:Myworld
Comment Utility
Thank you for the reply.
  I need the document library to automaticaly get the creation date of the document. Is it possible by writing VBA code to get the creation property of the file.
If i write VBA code to get the property how do i create a feature to staple it to the document library.
0
 
LVL 14

Expert Comment

by:RickEpnet
Comment Utility
I do not know VB so I would not be able to answer that one sorry.
0
 

Author Comment

by:Myworld
Comment Utility
Guys is there any one who can help me
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 14

Expert Comment

by:RickEpnet
Comment Utility
Click request attention
0
 
LVL 14

Expert Comment

by:VBClassicGuy
Comment Utility
Sub GetDateCreated()

    Dim oFS As Object
    Dim strFilename As String

    'Put your filename here
    strFilename = "c:\excel stuff\commandbar info.xls"


    'This creates an instance of the MS Scripting Runtime FileSystemObject class
    Set oFS = CreateObject("Scripting.FileSystemObject")

    MsgBox strFilename & " was created on " & oFS.GetFile(strFilename).DateCreated



    Set oFS = Nothing

End Sub
0
 
LVL 51

Accepted Solution

by:
tedbilly earned 500 total points
Comment Utility
Sorry but the create date in Sharepoint is when the item was 'Created' in Sharepoint, not created on your hard drive.  The only way to change this is a lot of custom code.  If the create date remains in the meta data then you can access it using code on the client.
0
 

Author Closing Comment

by:Myworld
Comment Utility
decide to use spfile object to get the file created property  system.io.file.creationtime
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Viewers will learn the different options available in the Backstage view in Excel 2013.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now