function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
efantiniefantini 

Special values for Date Fields

Hi all,

is it possible to create a Workflow Rule with a filter like the following?

ex. Opportunity Close Date  equals to TODAY - 2

Thanks

Enrico Fantini

 

ScotScot

I would love something like this too ... hope there's a positive answer.

This situation is made more critical due to a related problem: 
       Date constants in a workflow rule are interpreted using the individual record owner's date format. If you are an international organization with users in different countries, you can't build a global rule, since it will be interpreted differently depending on the owner. In theory, you can duplicate the rules including a test for the data format, but with the additional limit on the number of rules and the number of expressions in a rule, this quickly becomes unfeasible.

Scot

DevAngelDevAngel

Hi enfanti,

Great question.  Terrible answer.  No, you can't.  This seems like a really good feature to get into an upcoming release.  No sure how else you would use a date unless it has a reference point, even without the offset.  Seems like there should be a Today on the left as a field, or a TODAY as a special value on the right.

Lets see if we can get that in a future release.

Cheers