Trigger at First Business Day of Month

user_9467540 0
Viewed 298

I need to run a pipeline that starts at the first business day of month. It can be set in a trigger or in an if condition to run all the activities at this day.

Thanks in advance!

azure-data-factory-2
1 Answers

You could use an if condition activity with the following code:

@or(and(equals(dayOfMonth(utcnow()),1), and(greater(dayOfWeek(utcnow()),0),less(dayOfWeek(utcnow()),6))),or(and(equals(dayOfMonth(utcnow()),2), equals(dayOfWeek(utcnow()),1)),and(equals(dayOfMonth(utcnow()),3), equals(dayOfWeek(utcnow()),1))))
user_31108320
Related