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?

  • 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 Oct 24, 2012 at 19:23

2 Answers 2


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

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

This should work!

Reference URL

  • Please mark the correct answer! Nov 26, 2012 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, 2013 at 6:40
  • Post a new question, I will answer there! Also accept the answer on this question by marking the tick mark Apr 10, 2013 at 13:17
  • I have created new question.Please you can check in this link.sharepoint.stackexchange.com/questions/65398/…
    – user876869
    Apr 10, 2013 at 13:36

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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