Solved

creation date of document(sharepoint library)

Posted on 2010-09-05
9
981 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
ID: 33608232
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
ID: 33609629
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
ID: 33611118
I do not know VB so I would not be able to answer that one sorry.
0
 

Author Comment

by:Myworld
ID: 33699872
Guys is there any one who can help me
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 14

Expert Comment

by:RickEpnet
ID: 33700666
Click request attention
0
 
LVL 14

Expert Comment

by:VBClassicGuy
ID: 33701428
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:
Ted Bouskill earned 500 total points
ID: 33703768
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
ID: 33820679
decide to use spfile object to get the file created property  system.io.file.creationtime
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

912 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

22 Experts available now in Live!

Get 1:1 Help Now