+ Start a Discussion
Glenn Soden 9Glenn Soden 9 

How to update picklist value from a separate date field comparing to today's date?

Not sure but I cannot find a clear answer to this.  I have a status__c picklist value we want changed from "Installing" to "installed".   This should change based on a separate field that we created that has an "install_date__c" entry (date field). When system date matches this date field we have we would like the picklist value to change on status__c.   Any help would be appreciated!
Best Answer chosen by Glenn Soden 9
sukanya banekarsukanya banekar
Hi Glenn,

You can write workflow for this. 
1. Create workflow
2. Select appropriate criteria (install_date__c == Today())
3. Use Field update and update picklist field you want

I hope this will help you.

Thanks,
Sukanya

All Answers

sukanya banekarsukanya banekar
Hi Glenn,

You can write workflow for this. 
1. Create workflow
2. Select appropriate criteria (install_date__c == Today())
3. Use Field update and update picklist field you want

I hope this will help you.

Thanks,
Sukanya
This was selected as the best answer
Glenn Soden 9Glenn Soden 9
Ok, this is very staright forward.  But another question - I want the field to update from one pick list item to another.  But only one particualr picklist item not all when the rule triggers.  Any way to isolate the field update to just one of the potential current picklist items?
sukanya banekarsukanya banekar
Hi Glenn,

The another field you want to update is on the same object? I am not getting you question clearly.

Thanks,
Sukanya
Glenn Soden 9Glenn Soden 9
Actually I answered my own questiion when I built it out.  All godd!