This is probably very simple , but I can't seem to find a way of creating a date field that shows either the creation or modification date of another field.

AutoEnter Options, but not for field, for whole table.

Sorry , I didn't understand that

are you saying it's only possible for the entire table and not an individual field?

Sorry for my stupidity

Yes!

No.

fieldLog.fp7.zip

Comment, can you elaborate on that

sorry, i didn't see the attachment at first- Thanks

oK, I'm nearly there. How can I modify that calc so :

1) only the date shows - not the time

2) only the most recent entry shows , not a whole list

thanks very much

Why bother to got thru this if you are only interested in the Modification Date? Create a Field Date, and have it use the Date Modified Auto Enter.

Lee

Change the field type to date. Change the calculated entry to:

Get ( CurrentDate ) & Left ( fieldToWatch ; 0 )

If you want to log clearing the field as a modification, uncheck 'Do not evaluate if all referenced fields are empty'.

thanks

"Change the field type to date. Change the calculated entry to:

Get ( CurrentDate ) & Left ( fieldToWatch ; 0 ) "

Is this a Version 7 capability only, or can we check field-by-field in Versions 5/6 as well?

I haven't seen this before.

To expand on this thread: I can setup the Creation Date quite easily. But, how do you tag a Modified Date/Modified Time, for the entire record - any field gets changed?

Versions 5/6.

This should be easy, but I'm missing it.

Comment's calc would be

Status(CurrentDate) & Left( fieldToWatch, 0 )

in previous versions.

You create the modification date/time fields the same way you do for a creation one. Just change the desired type in the dropdown list which defaults to 'Creation Date'.

AFAIK my calc would not work at all in previous versions, since it wouldn't trigger.

Well, I SWEAR those Modification Options weren't there last week. I knew I had used them before. I'll blame it on a virus, but thanks for pointing out the obvious.

I tried Comment's logic in V5/6. It did detect the change to the field, for the entire file, not per record. I assume that is what it is supposed to do.

I stand corrected. When I made the Define Fields change, each record was marked with the same value. After that, it updated record-by-record. Very nice.

Thanks for the info everybody.

No, it's detecting (and logging) modification to a field per record. But it needs the "replace existing value" feature, which is new in ver.7.

I suppose a more complex routine could be devised to achieve the same in previous versions - see for example:

http://www.nightwing.com.au/FileMaker/demos2.html#d1

It's not terribly complex to log modification time and date in versions 5 and 6:

Stored calculation field:

Case(Field_to_be_monitored,"","") & Status(CurrentDate) &" "& Status(CurrentTime)

<Edit: I see Queue already gave essentially the same formula. I skipped too many replies