SharePoint List Question for the Gurus. Dynamic Date Column from reading title of another column that has DDMMYY ?

Posted on 2011-10-23
Last Modified: 2012-05-12
Hello Experts.

I have a column that shows the titles of uploaded documents.
For example the document  titles are respectively called  BBP 102211 Friday .doc. ( where the date is DDMMYY )

I have another column ,a list item using the matching date of the document on the same row.
In this instance I would have to enter October 21 , 2011.

Is there a way to have the date read of the aforementioned document title and dynamically populate the date list item?

The purpose:

I have a library where I have the non techies upload their daily documents.
On a separate page I have a web part that displays the current document from that library for the day.
I can't filter by created date because they don't always upload/ create them in succession.
I can't use modified date because they sometimes re-modify them.

They are not computer literate and to teach them how to fill the date list item ( column ) which I use to filter the current file ,would make them all nervous and crazy!

Your expertise is greatly appreciated.

Thanks in advance.
Question by:colonelblue
    LVL 18

    Accepted Solution

    Hi! What is the type of the field to want to write date to (DateTime/Text)?
    I see several options here:
    1) You can try to do it with calculated field, but I'm not sure if you can parse do title with standard functions ( - this is the simplest way because does not require custom coding
    2) You can create an ItemAdding event handler for the list ( and populated the field with the value based on doc title inside this handler - this will require custom coding
    3) You can create custom field type and custom field user control, that will populate the field with the value, based on doc title - this is the most difficult, and probably will work with standard list form only.

    So, I would advise - to use second option - it is flexible and quite easy to implement. If you need any additional info on this - please ask.

    Author Comment

    Hello  ivan, it s a Date and Time field, and I chose Date Only.

    Wow all the info you gave me seems complicated. I am not a coder.
    How would I implement what I needed to make the Date and Time field be dynamically filled out from reading the date on the document title name?

    Thanks in advance.
    LVL 18

    Expert Comment

    I'm afraid you cannot do that without custom coding (at least I don't know how). Can you use Visual Studio 2010 to create a feature with event handler? If yes, I can provide code for the handler.

    Author Comment

    :( Sorry to say I am not much of a coder nor familiar with Visual Studio,

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    755 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

    18 Experts available now in Live!

    Get 1:1 Help Now