Auto Enter Field - Modification Time

[Matt Leach]

I have a field that is currently set to Automatically Enter the Modification time of the record.

Is it possible to have the field pull the modification time only once?

I am trying to calculate the start and end time of a note by using an auto enter creation and modification fields. The problem is that if at any time the user goes back to edit a note, the original modification time will be overwritten and results in an inaccurate time.

Thanks in Advance

[Raybaudi]

Hi

create a third field that auto-enter a calculated value ( with a check into "Do not replace existing value for field ... ) and calc:

Case(

modification ≠ creation ; modification

)

[Matt Leach]

Thank you for the example, exactly what i needed.