Reporting Module - schedule send 1st business day of month

Ignition
1

Does anyone know the correct settings / crontab to send reports 1st business day of month?

I have tried this but sends each day that fits the category (up to 3 times if 1st is Monday etc.)

image

2

Create a boolean expression tag, "FirstWorkingDayOfMonth".
Set the expression to:

case(
	getDayOfMonth(now()),
	1,	case(
			getDayOfWeek(now()),
			2, true,	// Mon
			3, true,	// Tue
			4, true,	// Wed
			5, true,	// Thu
			6, true,	// Fri
			false
		),
	2, if(getDayOfWeek(now()) = 2, true, false), // 2nd = Mon
	3, if(getDayOfWeek(now()) = 2, true, false), // 3rd = Mon
	false
)

Schedule the report for every day. e.g., for 07:30.

Minutes:   30
Hours:     07
Days:       *
Months:     *
Weekdays:   *

Set the parameter tab as shown below.
FirstWorkingDayOfMonth

See Report Schedules | Ignition User Manual for what this is based on.

Alternatively, just send it out on the first of the month whether it's a working day or not.

2 Likes