Create a Day Counter Since a Field Change
Hello, Is there a way for a day counter to reflect how long since a field has been altered?
I have a STATUS field for a table and I want it to count days since the last time the status has c...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf your data entry is always on forms, and never Grid Edit, you can make a field called [Date / Time Status Last Changed] and have a Form Rule that says
When the record is saved
and
Status has changed
Change the value of the field [Date / Time Status Last Changed] to the current date/time.
But if the data entry might be by Grid Edit, then you will need to use an Automation or Pipeline to record the date/time when the status was changed.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
When the record is saved
and
Status has changed
Change the value of the field [Date / Time Status Last Changed] to the current date/time.
But if the data entry might be by Grid Edit, then you will need to use an Automation or Pipeline to record the date/time when the status was changed.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------