Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Calculated field for weekday not correct

Asked By: Teresa Farns Date: Sep 15, 2010 Category: Sharepoint Views: 2346

We use a calendar on Sharpeoint to track events. These events can be all day events that may start at 12:00 am on Thursday and go until 11:59 pm on Friday. I put in a calculated field based on start time so it displays the day of week the event starts along with start time of the event in a list.
This is the calculation I'm using =TEXT(WEEKDAY(([Start Time])),"ddd") It works great if the start time is after 12:01 am. If it is 12:00 am, it displays the day prior. For example Start time of 9/17/10 at 12:00 am will display the day as Thursday.

Anyone know how to correct this?

Tagged:calculated field for weekday not correct

2 Answers Found

Answer #1 Answered By: Vladi Gubler Answered On: Sep 28, 2010

Just a thought - why don't you just add one minute to the time value before getting the weekday value? You can probably find a way to do that in the same calculated field

Answer #2 Answered By: Teresa Farns Answered On: Sep 28, 2010

I tried adding a minute and an hour to the start time but cannot get it to work. The person entering events is just putting all day events in as 12:01 am to 11:59 pm. Was hoping to get away from that but not having much luck.

Didn't find what you were looking for? Find more on Calculated field for weekday not correct Or get search suggestion and latest updates.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Calculated Column using =LEFT() formula

Next: Lists

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.