Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Karunakar BuruguKarunakar Burugu 

Help needed regarding the Account Opportunity custom data format

Hi All,
I have a requirement to gather data using the below format from Account and opportunity. could you please help me how to achieve this format? I mean is it possible with collections?
 
Account NameOpportunity CreatedDateOpportunity Name
SamsungJan-22Opp1
  Opp2
  Opp3
AppleFeb-22Opp1
  Opp2
  Opp3
SamsungFeb-22Opp4
  Opp5
  Opp6
Imran TMImran TM
Hi 
Karunakar Burugu
,
 
You can use this below formula
 
Account.Name & " : " & Name & " : " & Text(Month(Today())) + "/" + Text(Day(Today())) + "/" + Text(Year(Today()))
 
Here you had Standard field if you want to use some Custom field than you should use this below formula
 
MM/DD/YYYY
 
Text(MONTH(Customfield__c))+"/"+Text(DAY(Customfield__c))+"/"+Text(YEAR(Customfield__c))
 
DD/MM/YYYY
 
Text(DAY(Customfield__c))+"/"+Text(MONTH(Customfield__c))+"/"+Text(YEAR(Customfield__c))
 
Hope this solve your issue if yes than mark as the best answer
 
Thanks,