http://www.endusersharepoint.com/STP/ SharePoint QA en Tue, 19 May 2009 19:18:13 +0000 http://www.endusersharepoint.com/STP/topic/calculated-values-in-date-field#post-6690 Thu, 14 May 2009 17:42:33 +0000 jcollins-mdmercy 6690@http://www.endusersharepoint.com/STP/ <p>I have a document library for storing presentations. About 10 new ones each week. I created a calendar view for the library. </p> <p>We have five different series of weekly meetings, abbreviated as GR, MR, NC, etc. The GR meeting is always at 8:30 am, MR is always at 8:15, NC at 12 noon, etc.</p> <p>Using a calculated column, the title displayed on the calendar concatenates the data from 4 columns. The series abbreviation is one of these four.</p> <p>When adding documents to the library, I would like to code the date field's display so that if the series = GR, the time automatically = 8:30, if the series is MR the time always = 8:15, etc.</p> <p>Is this something that can be done via a calculated value in a date field? If so -- how?</p> <p>Thanks so much!<br /> John </p>