Qrew LegendWhen you use Now() in a formula it's always the current time.
As they say, "Time waits for no man".
What "Anchor Date" do you Want to uSe instead. If you base the formula on the built in field [Date Created], then it would stable based on the date the record was first saved.
Hi Mark,
Thanks for the help!
The intention is that the record being update has a [Enabled For Execution](On/Off) state. That a user can come in and turn off and on at their leisure.
What I'm trying to do is create a field that captures the last time someone goes into the record, unchecks [Enabled For Execution] and update the field with the timestamp when the user does this. We also use a text field with the log user entries as well. We also use a custom date time format Month/Day/Year Hour:Min:Sec (24hr).
Date Created/Modified doesn't work for us. Since the user is not always creating the record. For Date Modified, we are using the QB RESTFul API. So the backend generally accounts for 99.9% of last modified.
Qrew LegendYou can have a scalar (data entry) field. Then use a Form Rule to populate that field when certain conditions are true or when the record is saved and certain conditions are true. The "source" of the value in the form rule can be your formula field that you have now.
Thank you!
