You need to sign in to do that
Don't have an account?
Shoshinsha81
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)
)
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)
)
https://developer.salesforce.com/docs/atlas.en-us.usefulFormulaFields.meta/usefulFormulaFields/formula_examples_dates.htm