recording when a status changes and date stamping it

Question

Hello,We have a status for each of our wells. Our GIS person has a connected table to our Wells table.
He wants to see a date stamp for when a status changes.

I made a field that has this formula [BM STATUS]&amp; " " &amp; Now()
which results in this, SPUD 02-24-2022 01:21 PM, but they don't want the text in a date field. understandably. So how can I date stamp when only that field changes without a pipeline?
------------------------------Renee Hansen------------------------------

paulpeterson1 · Answer

If they are using the form to update the data, you could use a form rule.------------------------------Paul Peterson------------------------------

reneehansen · Answer

How would a form rule work here? I don't see an option to do an action when a field changes.------------------------------Renee Hansen------------------------------

donlarson · Answer

Renee,Try this structureBy having a Status Change Table, you now know the lifecycle of the well.&nbsp; &nbsp;The current status of the Well is the very last record added to the Well Status Change table.&nbsp; You can get that value with a Reverse Relationship or a Formula Query.The Date Time Stamp that your person wants is the Date Created FID #1 from the table. ​------------------------------Don Larson------------------------------

paulpeterson1 · Answer

The way I have used form rules to time stamp status changes is to create a New Status field and set the form rule to fire when the status does not equal the new status and in the form rule change the New Status to the Status.------------------------------Paul Peterson------------------------------

Forum Discussion

recording when a status changes and date stamping it