Change Stage according to Next Stage Change Date

Question

Hi everyone,

Could you please help me doing a trigger where I change the Lead Stage according to a Next Stage Change Date?

So basically, what I want is:

Next Stage Change: 02/12/2015

Current Lead Stage: No Answer (1)

Next Lead Stage: No Answer (2)

Does Salesforce do the trigger automatically?

I want the lead stage to change automatically without doing any update on the lead.

Thanks

Phil Witzmann · Answer

Hello Becka!

Thanks for your prompt answer.

Really? That's perfect. I've tried to do with a workflow but it wasn't working.

I was using this formula:

IF( Now()> Next_Stage_Change__c , ISPICKVAL(Lead_Stage__c, "No Answer (2)") , ISPICKVAL(Lead_Stage__c, "No Answer (1)"))

What do I have to change or improve so lead moves to another stage without updating any field?

Thank you

Apex