QOTD: SharePoint Start Time Field
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
You’re not kidding! I spent an entire day coding a complex solution, went home with a sore arm from patting myself on the back, came back the next morning to find one simple check box already built in to do the entire thing. Oh the lessons we learn (or don’t learn)
:-)
Sometimes our thoughts are really complex. Very often there are so simple solutions. Thank you Eric.
Plain and simple!
In the same range of ’simple’ how-to with SharePoint field dates:
How to sort by a Date field: http://www.endusersharepoint.com/2010/01/18/create-order-in-a-sharepoint-date-column/
This is not counting Dessie’s post on Excel calculations in SP:
http://www.endusersharepoint.com/category/author/dessie-lunsford/
Greg
Thanks for this- it’s good to be reminded that sometimes we just need to get out of our own way. :-)
Nice, I did know that but sadly i found out after having used quite a bit of time trynig my hand a complex formulas and other ways to fill my day. :P