Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

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

2 Answers

up vote 2 down vote

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 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 at 13:17
I have created new question.Please you can check in this link.sharepoint.stackexchange.com/questions/65398/… – user876869 Apr 10 at 13:36
up vote 0 down vote

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

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.