I have created Opportunity Name workflow rule as follows
Account.Name & " | " & PRIORVALUE(Name) & " | " & TEXT(Today())
Account Name | Priorvalue = whatever is entered user | today date in year.month.date
Here is the screenshot of the opportunity
But when my process builder creates renewal opportunities for the future date. the current opportunity name becomes prior value and created opportunity looks like this
Is there a way of resolving this? or writing a better workflow rule which can take care of this? Functionally i am open for suggestions as well.
Best Regards Prashant