-
ChatterFeed
-
0Best Answers
-
1Likes Received
-
0Likes Given
-
6Questions
-
6Replies
Formula Assistance
Need to create a formula checkbox to check if time of record creation is within business days (Excluding weekends).
Business hours 8 am to 5 pm Central Time
Thanks in advance.
Business hours 8 am to 5 pm Central Time
Thanks in advance.
-
- Shoshinsha81
- July 14, 2016
- Like
- 0
- Continue reading or reply
Formula HELP !!!!!!!!!
I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.
Thanks in advance
Thanks in advance
-
- Shoshinsha81
- April 06, 2016
- Like
- 1
- Continue reading or reply
Business Day Formula
I would like to create a formula based on the Case Opened date and Case close date.
Current Business Hours
Schedule - Monday to Thursday 8 am to 8 pm
Schedule - Friday = 8 am to 6 pm
Anyone please help. Thanks
Current Business Hours
Schedule - Monday to Thursday 8 am to 8 pm
Schedule - Friday = 8 am to 6 pm
Anyone please help. Thanks
-
- Shoshinsha81
- March 29, 2016
- Like
- 0
- Continue reading or reply
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)
)
-
- Shoshinsha81
- March 10, 2016
- Like
- 0
- Continue reading or reply
DISTANCE( BillingAddress, GEOLOCATION(37.750,-122.203), 'mi' ).
I'd like to display the distance between the "BillingAddress" and the given location above "ISTANCE( BillingAddress, GEOLOCATION(37.750,-122.203), 'mi' ) in MILES.
Thanks in advance. :)
Thanks in advance. :)
-
- Shoshinsha81
- March 04, 2016
- Like
- 0
- Continue reading or reply
-
- Shoshinsha81
- March 02, 2016
- Like
- 0
- Continue reading or reply
Formula HELP !!!!!!!!!
I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.
Thanks in advance
Thanks in advance
-
- Shoshinsha81
- April 06, 2016
- Like
- 1
- Continue reading or reply
Formula HELP !!!!!!!!!
I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.
Thanks in advance
Thanks in advance
- Shoshinsha81
- April 06, 2016
- Like
- 1
- Continue reading or reply
- Shoshinsha81
- March 02, 2016
- Like
- 0
- Continue reading or reply