+ Start a Discussion
learnSFlearnSF 

work flow update field not fire

Hi,

 

Here is my formula field say TaskFlag: IF( DAY( TODAY() ) =20, 'pass', 'fail')

 

Now I wrote one time based workflow that when TaskFlag become pass,fire flowflow immidiate and update Account.Net__c field inside account.

 

I have noticed that workflow didn't fire even TaskFlag set to 'pass'.

 

Can anyone drive me that how to achive this functionality?

MarkSilberMarkSilber

Time based workflow can only be driven from a date field, not a text or picklist. In order for an entry to made in the Time Based workflow object, your workflow entry criteria must be met. At that point, the entry is inserted in the time-based workflow table to be monitored for future execution based the number of days before or after a date in your object.

You will never be able to have a dynamic time-based workflow as you are trying to indicate with your formula below. You would instead create an entry criteria (for example, Status = "Active" ) and then a time-based workflow action to fire at 20 days past x date. You can't use today since that's a dynamic field.

Message Edited by Mark Silber on 03-20-2009 12:10 PM