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!
October 7th, 2009 9:33pm
Check out this blog post to see how to do it for year/month.(http://intellects.in/2009/03/04/sharepoint-calculated-columns-formulas/)
October 7th, 2009 10:20pm
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!
October 8th, 2009 2:30am
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/
October 31st, 2010 3:33pm
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.
November 13th, 2011 4:41am