dharkangel
MIS
I have an issues list where I've created a calculated field called 'Close
Date'. Here is the formula I created for it:
=IF(AND(Status="Closed",CloseDateOG=""),Modified,IF(AND(Status="Closed",CloseDateOG<>""),CloseDateOG,""))
The way it works is, if a user closes an issue by setting the 'Status' field
to 'Closed', the 'Close Date' field is filled in with the 'Modified' date.
'CloseDateOG' is text field where users used to be allowed to manually fill
in the 'Close Date' which led to dishonest closed dates, which is why I
changed it.
The problem I have is unpredictable. Today I looked at the list and the
'Close Date' field was showing values of '12/30/1899'. When I looked at the
actual formula of the field it was set to '=12/25/2005'. This is the second
time this has happened. Has anyone seen this behavior?
Date'. Here is the formula I created for it:
=IF(AND(Status="Closed",CloseDateOG=""),Modified,IF(AND(Status="Closed",CloseDateOG<>""),CloseDateOG,""))
The way it works is, if a user closes an issue by setting the 'Status' field
to 'Closed', the 'Close Date' field is filled in with the 'Modified' date.
'CloseDateOG' is text field where users used to be allowed to manually fill
in the 'Close Date' which led to dishonest closed dates, which is why I
changed it.
The problem I have is unpredictable. Today I looked at the list and the
'Close Date' field was showing values of '12/30/1899'. When I looked at the
actual formula of the field it was set to '=12/25/2005'. This is the second
time this has happened. Has anyone seen this behavior?