Get the date a field change was entered

I'm trying to create a derived field to determine the date that a field change was entered on. I can use the "date last changed" keyword to get the effective date of the change, but I'm trying to get the date that change was entered. For example, I change the Position.Active field to inactive on 3/25/2025 effective on 3/1/2025. I'd like to return the 3/25/2025 date. Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

smodarressiyazdi

Can you do this on the form using another persistent field that is date type, rather than a derived field?

Position.Active

when value changed

NewPersistentField = system current date

robert-canham

That might work, but I don't think it would catch it if someone were to update from a list by making it updatable or if they upload using ISD.

cleverly

Try something like this:

Position is a BusinessClass
    owned by hr

    Derived Fields

        ActiveLastChangeEntered is a DerivedField
            type is Date
            for each audit log records descending
                if (each.changed field names = "Active"
                or  each.changed field names like "Active,*"
                or  each.changed field names like "*,Active"
                or  each.changed field names like "*,Active,*")
                    return each.entry stamp

I'm not clear on whether you'd want to completely ignore future dated changes that aren't effective yet. If you do, you might need to add a test for that in there too.

robert-canham

Thanks Michael, that did the trick. I added a default return at the bottom to give the create stamp of the position for new records.

Copyright © 2025 Infor. All rights reserved.