• Shoshinsha81
  • NEWBIE
  • 10 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 6
    Questions
  • 6
    Replies
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. 
 I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.

Thanks in advance
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
 
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) 
)
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. :)
 
How to create a trigger to send email alert after 30 minutes? 
 I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.

Thanks in advance
 I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.

Thanks in advance
How to create a trigger to send email alert after 30 minutes?