Skip to main content
Topics#Data ManagementSystem Administrator의 질문
System Administrator (tech9logy creators) 님이 #Data Management에 질문했습니다
2013년 4월 4일 오후 1:26

create tasks only during business hours

I'm trying to create a workflow that automatically creates a task but only during set hours of the day. We don't need to exclude weekends.

 

Any pointers?
답변 2개
  1. Aaron DeRan (Deloitte)
    2013년 4월 4일 오후 1:45
    Add into your workflow criteria:

     

    AND(

     

    NOW() >= DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())) & "08:00:00Z",

     

    NOW() <= DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())) & "17:00:00Z"

     

    )

     

    This should consider the rule to only fire if the current moment in time is between 8am - 5pm.

     

    I did not test this so let me know if you get an error and if so, what it is.
답변을 작성하세요...
0/9000