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?
View Complete Post