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?
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2011 2:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics