+ Start a Discussion
Shoshinsha81Shoshinsha81 

Formula Help !!!

Want to modfiy formula field to show AM or PM. Thank

Current Value -  Formula: 2016-03-04 16:05
Desired Value - 2016-03-07 03:35 PM


CURRENT FORMULA: 
IF (DATEVALUE(Date/Time Field__c) >= 
DATE ( YEAR (DATEVALUE(Date/Time Field__c)),3,1) 


14- 
CASE( MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),3,1) - DATE (1900,1,7),7) , 
0,7,MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),3,1) - DATE (1900,1,7),7)) 

&& 
DATEVALUE(Impact_Start_Time__c) < 
DATE ( YEAR (DATEVALUE(Date/Time Field__c)),11,1) 


7- 
CASE( MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),11,1) - DATE (1900,1,7),7) , 
0,7,MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),11,1) - DATE (1900,1,7),7)) 
), 
LEFT ( TEXT (Impact_Start_Time__c - 7/24 ), 16), 
LEFT ( TEXT (Impact_Start_Time__c - 8/24), 16) 
)