Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list built in sharepoint 2010 which contains date column. I need todays date should be automatically fills that column when adding new item in the list.

for e.g: if the todays date is "1" i need to fill that field as 001, but if the todays date 11 i need to fill that field as 011.

What type of column i can select? How can i achieve my requirement?

share|improve this question
1  
Hi, it seems your accept is 0%. If answer was helpful, you're supposed to "accept" it (click check mark next to this answer, below the rating buttons). This will encourage site experts help you more eagerly and also it will indicate the answer as a correct one, so that other users will know that the solution is correct. Please read our FAQ for more details: sharepoint.stackexchange.com/faq#howtoask –  Andrey Markeev Oct 24 '12 at 19:23
add comment

2 Answers 2

You can probably do it using a Calculated Field. The syntax is mostly like Excel, so you can sort out your formula there.

share|improve this answer
add comment

You can use Calculated Field as lgaud said and then use following Formula:

=CONCATENATE("0", TEXT([Today],"dd"))

This should work!

Reference URL

share|improve this answer
    
Arsalan, Thanks for your answer. It works for me. –  user876869 Nov 26 '12 at 7:07
    
Please mark the correct answer! –  Arsalan Adam Khatri Nov 26 '12 at 7:58
    
Hi Arsalan, The first 6 digits would come from the current day’s date.the last 3 digits would start at 001 and increment throughout that day. So if the date is 03/12/13 the first list value number will be 031213001 and the second should be 031213002. Is it Possible? How can i achieve it? –  user876869 Apr 10 '13 at 6:40
    
Post a new question, I will answer there! Also accept the answer on this question by marking the tick mark –  Arsalan Adam Khatri Apr 10 '13 at 13:17
    
I have created new question.Please you can check in this link.sharepoint.stackexchange.com/questions/65398/… –  user876869 Apr 10 '13 at 13:36
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.