date field modification

[IEW]

I have a field called "Date of Last Activity". It is checked in the modificaton box and is "date". The date changes to current date when the layout is opened, this is not what I want. How do I keep the date from changing until the record is really modified or accessed.

TIA

Ivan

[Søren Dyhr]

Sorry I can't follow if you define the field as date with the autoenter option "Modification Date" do you really have to modify a field or two, to make the field change. But if you instead define the field as a calcfield with the unstored "Get ( CurrentTime )" or Get ( CurrentDate ) ...will the behaviour be as you descriped - Each time a layout event is trigged.

--sd

[transpower]

You could change the option in Layout Setup. Uncheck "Save record changes automatically." Now you'll have to manually commit the records, which should then cause the modified on date to change only then.