Skip to main content
I am trying to get a rule to fire when create date on a case is between 5:00 pm PST Friday and 4:00pm PST Sunday. Suggestions?
4 risposte
  1. 6 dic 2018, 21:15
    You may need to tweak the PST / UTC Offsets, but I think this might work 

     

     

    OR(

    AND(

    WEEKDAY(DATEVALUE(NOW() - (8/24) )) = 6,

    TIMENOW() >= TIMEVALUE("17:00:00.000")

    ),

    WEEKDAY(DATEVALUE(NOW()- (8/24))) = 7,

    AND(

    WEEKDAY(DATEVALUE(NOW()- (8/24))) = 1,

    TIMENOW() <= TIMEVALUE("16:00:00.000")

    )

    )

     

     
0/9000