Calculated column with Modified date doesnât work properly
I have strange problem. In my document library when document is modified I have to show formatted date e.g. 01 APR 2010. So I have created a calculated column called Modified Date. Formula is used =TEXT([Modified],"dd mmm yyyy"). It works fine sometimes and some times shows 31 Dec 1899. I replaced Modified with [Modified] and it resolved the issue. But again an issues is some times dates are formatted correctly and some times differently e.g. 2/23/2010 11:00 AM is formatted as 05 Apr 2010. In the same document library it works for some items and doesn't works for others items. Can any one help me on this issue. Thanks,Chirantan
April 7th, 2010 11:24am
It still happens in 2010. Any idea how to solve this issue?
June 2nd, 2011 2:37pm