Calculated column using CONCATENATE

Question
Sign in to vote
0
Sign in to vote

Hi Everyone,

I created one Calculated date column format like 2013-04-16 (YYYY-MM-DD) and again

i created one more Calculated Number column format like 0001-13.

Now what my question is when i am adding date into Date column, depending that Date column

i want this functionality.

0001-13........(here 0001 is the autogenerated countable number like 0001,0002,0003 and so on and 13 is the year).                    

0002-13

0003-13

Please help me in this .

As per my opinion you can achive this requirement in Calculated Column so just create simple Event Receiver for ItemAdding Event.

OR

If you want to use ID field in Calculated column then go for SPD workflow as per my previous solution for your  given post link http-://social.msdn.microsoft.-com/Forums/en-US/sharepointdevelopmentprevious/thread/867f2739-80f4-4b68-ab83-d354296ab9e9