Concatenation function in office MOSS 2007
I have created a list in Office sharepoint 2007. I have created a new coloumn, that needs to be a calculated value of Date(ie created by) and ID.
I used "=CONCATENATE(TEXT([created], "dd-MM-YYYY"), " ", [ID])." It is working fine.
Problem is If I create a new item only date section is displayed, and if try again go to calculated value section and just give ok, It is working fine.
Kindly help me out in this issue.
May 6th, 2011 12:33am