Have a "CreatedDay" custom list calculated field set to the standard =TEXT(WEEKDAY([Created]),"ddd"). When an new item is created, it is calculated properly. When a change to that item is made, the Day of Week list calculated field always changes to Sat when item change workflow is initiated.
When looking at the Calculated Field Formulas article from Microsoft dated May 2010, under "Show dates as the day of the week" it shows examples of that formula using a date only where I am using Created, which is a Date-Time field. This has always works properly in WSS 3.0, but in Sharepoint Foundation 2010, this change to Sat keeps occuring. I can't find any forum posts on this and am lost on why it is changing. Has anyone ever seen this? Is there a way to single step in Sharepoint Designer to determine when and why this change is happening? I am not a real programmer so am just using our Sharepoint website and SPD 2010 to create my app using this custome list. Would really appreciate anyone's advice on thi