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

Hello Alan

i havent seen this but to try the way you read about, what about making another column called dateonly and make it a calculated column of date only type and set it to be the CreatedDay columns value thus giving you only the date to work with, then run your other calculated column from that one instead.

Sergio - Why I can't explain how CreatedDay is stable using Created (Date-Time) in WSS 3.0 and my other site migrated from WSS 3.0 to SFS 2010, I took your advice.   I added another calculated field named CreatedDateOnly with formula =[Created], Data type returned: Date and Time, and Date and time format; Date Only.

I then changed the CreatedDay calculated field to =TEXT(WEEKDAY([CreatedDateOnly]),"ddd").  It now retains the proper day of the week it was created after any change.  I tried a dozen other things to resolve this, but your simple answer seems to have stabilized the issue.  Thanks for your help!

My last reply that this did not fix the problem when I reactivated the workflow was deleted by someone from this forum post. 

I still have this issue with the calculated field and will probably end up calling Microsoft Tech Support to have them help me figure out why this works in my WSS 3.0 version of our Sharepoint Help Desk app and not in the SFS 2010 version.  I have the exact same formula in the calculated field for both versions.  The SFS 2010 version always changes to "Sat" after any modification and there is no place in the workflows that get invoke when items are changed that this calculated field or any elements in the formula get touched.

Hi,

Did you ever get a cause for this ?

I sometimes get the same symptom, not in sharepoint but for a cell in Excel 2013 with a display format of "ddd" ; and only closing and re-opening the workbook seems to resolve it ?

k.rgds Simon