You need to sign in to do that
Don't have an account?
The Online 401k
Formula in Workflow Field Update
I'm trying to copy one custom date field to another when the first one is populated. I set up a workflow rule with a field update, but I'm not sure how to copy the date using a formula. I tried using the DATE and DATEVALUE functions, but no luck.
Is there a formula that will copy one custom date field to another?
If both fields are of type Date then you just put the second field in the formula and hey presto. However, I have had problems with Standard fields that say they're dates but expecting Text as the result. In these cases, oddly, try: TEXT(mycustomdate__c).
Can you be more specific about what fields you're trying to set and any error you're getting on Check Syntax ?
All Answers
If both fields are of type Date then you just put the second field in the formula and hey presto. However, I have had problems with Standard fields that say they're dates but expecting Text as the result. In these cases, oddly, try: TEXT(mycustomdate__c).
Can you be more specific about what fields you're trying to set and any error you're getting on Check Syntax ?
I have a lookup field .. when i click on the lookup icon and select one value from the list... the value gets into this field... I want the same field value to be auto filled in another field(text)..
I used just the field name in the formula... but it doesnt work :(
Can you paste in the formula you've tried as it should be very straightforward?
For example, to add a formula field to an Opportunity that holds the Account name you'd just use:
Account.Name
I'd also question why you want to do this in the first place, unless you're appending some additional information?
BTW, please note it's better to ask a new question in a new thread, you'll get more chance of a reply as a new thread than a comment on an existing one.