+ 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.