Author: Eric Alexander, Moderator, Stump the Panel

lisettelovebug writes on Stump the Panel:

I have a start time and an end time on the calendar. What I want to do is a view that only has the date and not the time. I do not want the user to have to put more information in if it’s possible.

I have a formula that works in excel, but does not work in sharepoint. My Start Time column looks like this:

10/11/2010

This is the formula i am using

Code:
=LEFT(Start Time, find("",Start Time) -1)

I’m not sure what i am doing wrong. Any help would be greatly appreciated. Thanks.

This one, fortunately, does not need a complex calculated column to pull off. Simply create a new calculated column from the Start Time field. Set the data return type to Date and Time and set the format to Date Only.

Sometimes the simplest answers are right in front of our face and our brains take over trying to over complicate the situation, present company included.

Author: Eric Alexander, Moderator, Stump the Panel

Eric Alexander is a SharePoint Administrator working in the Higher Education sector. He wears many hats in this role and enjoys leveraging SharePoint to build solutions to solve problems across campus. You can find him on Twitter as PirateEric and lurking in the Stump the Panel forums.
http://feeds.feedburner.com/EricsSharepointAdventures