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 04/11/13 the first value of the list should be will be 041113001.

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

  • so you mean the auto-increment column will reset the other day and start from 1 again ? Commented Apr 10, 2013 at 14:27

1 Answer 1


First Create one Auto increment column check this below link


After that create One more Calculate column here you can bind Two Columns (DATE+Auto Increment Column)

=Text([DATE Column],"DDMMYYYY")+[Auto Column]

Second Option Fully OOB

Created Two Calculated Columns and one Date column

First is Auto Column enter image description here

Second one is DateAuto (mix of date and autonumber) enter image description here

let me if you have know any difficulties......

  • The requirement says about auto increment on daily basis. Both the solution you provided will not satisfy this requirement. Commented Dec 22, 2014 at 20:23

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.