AnsweredAssumed Answered

How come the calucated value for the field was not executed?

Question asked by liyangao on Nov 7, 2013
Latest reply on Oct 11, 2016 by philmodjunk

I have one calcuated value for a new field and somehow the field was still empty after I defined it in the management database window. I wondered why.

 

I have imported a date field (called DateImp) from file and I want to define a new date (NewDate) field as auto-enter calculation replaces existing value with always evaluation to keep the existing value and to get the current date for all newly generated records. The calculation looks like the following:

If (IsEmpty(DateImp); Get (CurrentDate); DateImp). The option of Do not evalute if all empty was unchecked.

 

How come the new date field was still empty after the mangement database window is closed? It seems that it was not executed at all. Do I have to initilize the field or what?

 

Would you please help me to check what went wrong?

 

Thanks a lot,

Liyan

Outcomes