function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SUMIT BANERJEESUMIT BANERJEE 

How to change DATE/TIME formate in formula field

2017-02-02T15:35:00.000+0000

I want to change into Tuesday, February 2nd at 10:30am

Please help on this
 
NagendraNagendra (Salesforce Developers) 
HI Sumit,

Please check this 
IF( LEN(TEXT(MONTH(date__c))) > 1 , TEXT(MONTH(date__c)), "0" + TEXT(MONTH(date__c))) + "-" + IF(LEN(TEXT(DAY(date__c))) > 1 , TEXT(DAY(date__c})), "0" + TEXT(DAY(date__c))) + "-" + TEXT(YEAR(date__c))
                                                       (OR) 
TEXT(MONTH(Date__c))+"/" +TEXT(DAY(Date__c))+"/" +TEXT(YEAR(Date__c))

Regards,
Nagendra.