I am trying to utilize calculated columns to give me specific date/time data. When I create a calendar event in SharePoint a "Start Time" value is created which looks something like 2009-10-07... Now what I would like to do is create a custom column for the year, month, and day individually. I however can not figure out how to write the Custom Column Formula to accomplish this. End result would provide me with a column for Start Time, Day, Month, and Year. Any help is greatly appreciated. Thank you!

Check out this blog post to see how to do it for year/month.(http://intellects.in/2009/03/04/sharepoint-calculated-columns-formulas/)

Thanks! I was able to get this to work using the link you provided and slightly editing his examples. In case anyone is interested here is what I came out with. I was using these formulas to create a seperate column for Day, Month, and Year. Year: =TEXT(YEAR([Start Time]),"0000") Month: =TEXT(MONTH([Start Time]),"00") Day: =TEXT(DAY([Start Time]),"00") Thanks again!

Check out this blog post to see how to do it for year/month. (http://intellects.in/2009/03/04/sharepoint-calculated-columns-formulas/) The above link is changed to http://sharemypoint.in/2009/03/04/sharepoint-calculated-columns-formulas/Sameer Dhoot My Blog : http://sharemypoint.in/

check this calculated columns formulas referrence http://blog.raminassar.com/2011/11/13/examples-of-using-calculated-column-formulas/Regards, Rami M. Nassar (MCP, MCTS, MCPD) My Blog E-Mail Don't forget to click Mark as Answer on the post that helped you.