Can someone show me how to create a calculated column that displays the date only? I'm using the microsoft absence planner.
I am simply trying to display a date without the time. I'm getting inconsistent results. Someone suggested that I simply add a day but that is not consistent.
I created a calcualted column to show me the day that Sharepoint thinks the time value has. The results are disappointing to say the least
someone suggested this formula since it seems to be always off by a day:
StartDate is a calculated column = =DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]+1))
*sometimes this formula displays the right info, sometimes not
The last column is just = Day_[Start Time] so I can try and figure out what is going on :(
Attendance item System Account Other 6/28/2010 12:00 AM 6/29/2010 28
Attendance item System Account Jury Duty 9/29/2009 12:00 AM 9/30/2009 29
Attendance item System Account Jury Duty 9/29/2009 12:00 AM 9/30/2009 &nbs
View Complete Post