Hi everyone!
This feels like a really stupid thing to ask, and i'm unsure which is the right channel - but how do you create a property which will always be 'today'?
My current work-around for this is that I've set up a daily scheduled workflow that updates every single property on a deal each day and re-stamps it as 'today' but this is...
1 - annoying for the activity logs, when you have workflows in the view
2 - surely not the best way to do it
3 - scares me that I'm at 6M total enrolments so far on this workflow for just one object...
I am referencing the 'today' property in many other calculated properties (i.e time between a date and 'today'), for reporting, and it's used in many other things as well that I would love to unpick.