field containing modification or creation date

[Robert Collins]

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.

[aaa]

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

[Robert Collins]

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

[aaa]

Yes!

[comment]

No.

fieldLog.fp7.zip

[Robert Collins]

Comment, can you elaborate on that

[Robert Collins]

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

[Robert Collins]

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

[Lee Smith]

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

[comment]

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'.

[Robert Collins]

thanks

[NYPoke]

"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.

[NYPoke]

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.

[-Queue-]

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'.

[comment]

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

[NYPoke]

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.

[NYPoke]

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.

[comment]

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

[BobWeaver]

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