Track if field changed in report

[Tziere]

Hi All,

I was wondering if it was possible to filter records in a report based on the fact if a boolean field was changed on a particular day.
I know that you can filter on modified, but that relates to all fields of the record, not just the one field.

Kind regards!

[Maximus]

Hello,
If you need it just for one field, then the easiest way I believe is:
1. Create a new 'date' type filed (don't add it to an entity layout).
2. Create a formula that will set a date to this field when your desired field has changed.
3. Utilize this new date field in a report.

[Tziere]

Thanks for this nifty workaround!