Field validation when close date has been changed to a date greater than the current close date.
I have a field validation that checks for a change to the Close Date and, if so, forces a change to another field, Latest Opportunity Status (see code below).
((PRE('<CloseDate>') <> [<CloseDate>]) AND (PRE('<ltLatest_Opportunity_Status_ITAG>') <> [<ltLatest_Opportunity_Status_ITAG>])) AND ((PRE('<CloseDate>') <> [<CloseDate>]) AND ([<ltLatest_Opportunity_Status_ITAG>] is not null))
Now I want to tweak it further to only trigger it when the close date has been changed to a date greater than the current close date. Is that possible? And, if so, how? I have tried various combinations but have not been able to get it to work.
((PRE('<CloseDate>') <> [<CloseDate>]) AND (PRE('<ltLatest_Opportunity_Status_ITAG>') <> [<ltLatest_Opportunity_Status_ITAG>])) AND ((PRE('<CloseDate>') <> [<CloseDate>]) AND ([<ltLatest_Opportunity_Status_ITAG>] is not null))
Now I want to tweak it further to only trigger it when the close date has been changed to a date greater than the current close date. Is that possible? And, if so, how? I have tried various combinations but have not been able to get it to work.
0