Skip to main content
Level 3
May 22, 2020 9:13 AM UTC
Solved

Create scheduler several times a days only from monday to friday

Hi,

 

I want to create a workflow that runs several times a day but only on the working days (monday to friday). I tried to fill scheduler with different options and see preview schedule but it looks it does take into account only the one option at the time and is not possibile to make any combine configuration.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
rahushAccepted solution
Oct 30, 2020 7:52 AM UTC

Hello gabrieleg615679,

 

You may use Test activity after the scheduler to run the workflow multiple times only on weekdays.

 

The Formula that you should use is : Lower(DateFormat(GetDate() ,'%A')) == 'sat' OR  Lower(DateFormat(GetDate() ,'%A')) == 'sun'.

 

By using the above formula Test transaction will point to End Activity(for Saturday and Sunday) and default transaction will point to your workflow(for Monday to Friday)

 

Regards,

Rahul S

 

 

 

3 replies

aveggianiAuthor
Level 3
May 25, 2020 12:46 PM UTC

We tried this function "WeekDay(GetDate())=6" on a test after the scheduler but we receive this message of error

 
25/05/2020 14:34:21test1XTK-170006 Unable to parse expression 'WeekDay(GetDate())=0'.
 25/05/2020 14:34:21test1XTK-170007 Unknown function 'WeekDay'.
Translate
rahushAccepted solution
Oct 30, 2020 7:52 AM UTC

Hello gabrieleg615679,

 

You may use Test activity after the scheduler to run the workflow multiple times only on weekdays.

 

The Formula that you should use is : Lower(DateFormat(GetDate() ,'%A')) == 'sat' OR  Lower(DateFormat(GetDate() ,'%A')) == 'sun'.

 

By using the above formula Test transaction will point to End Activity(for Saturday and Sunday) and default transaction will point to your workflow(for Monday to Friday)

 

Regards,

Rahul S

 

 

 

Translate
Sukrity_Wadhwa
Level 4
Nov 18, 2020 9:58 AM UTC
Hi @aveggiani, Was this solution helpful to resolve your query? Do let us know. Thanks!
Translate
Sukrity Wadhwa