title: Sharepoint Calculated Column - LEFT()
body: <p>I am trying to find the substring of the start time (I just want the date) field using a calculated column in SharePoint 2010 on a date/time field.</p>
  
  <p>I am using the =LEFT() command (please see attached images)</p>
  
  <p>As you can see the formula validates but doesn't show the correct output</p>
  
  <p>Please note I am restricted to out of the box SharePoint only, SharePoint designer has been disabled and this being a Calendar List, infopath is out of the question.</p>
  
  <p><img src="https://i.stack.imgur.com/JJ24Q.png" alt="List View"></p>
  
  <p><img src="https://i.stack.imgur.com/wDWfE.png" alt="Calculated Column"></p>