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,