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.
If it helps, when it's important to have a baseline date/time, etc. I'll create a pipeline based on the record create/update and write the date/time to a field that won't change when NOW() changes on each refresh or record load. It's a way of time stamping something like a "baseline". they are usually quick and easy pipelines to do - just don't forget if you use the current system time in jinja you need to adjust it for timezone.
