I've realized it's not possible to set a date format to DDMMMYYYY in Salesforce. We're using this format within our org and we already have some automated process in different applications and software where we use it so it's simpler for us to create some custom fields that will "translate" dates in a standard format into the one I've mentioned above
So I want to create 2 custom fields in the object "opportunity products".
One will be showing start date from a field ServiceDate which is a standard field.
The next one will be showing End date from a field End_date__c
Example:
18/07/2017 should be shown as 18JUL2017
Could you show me how to define such a formula or function?
2 件の回答
You Should be able to split the string based on / and then for the month part use the case function to assign month as JUL and append between other two substring.
Thanks,
JS
