# Reporting Module - schedule send 1st business day of month

**URL:** <https://forum.inductiveautomation.com/t/reporting-module-schedule-send-1st-business-day-of-month/89797>\
**Category:** Ignition\
**Tags:** reporting\
**Created:** [May 2, 2024, 2:15am UTC](https://forum.inductiveautomation.com/t/reporting-module-schedule-send-1st-business-day-of-month/89797 "2024-05-02T02:15:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bprendergast](https://avatars.discourse-cdn.com/v4/letter/b/5fc32e/32.png) [@bprendergast](https://forum.inductiveautomation.com/u/bprendergast)\
**Post date:** [May 2, 2024, 2:15am UTC](https://forum.inductiveautomation.com/t/reporting-module-schedule-send-1st-business-day-of-month/89797/1 "2024-05-02T02:15:25Z")

</div>

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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/7/77dd4b7641c5b0736b53d2bfb23e0d414f757dfc.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 2, 2024, 4:11am UTC](https://forum.inductiveautomation.com/t/reporting-module-schedule-send-1st-business-day-of-month/89797/2 "2024-05-02T04:11:22Z")

</div>

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

```python
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.

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

```

Set the parameter tab as shown below.  
 ![FirstWorkingDayOfMonth](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d8ae6c9870bc365a28bd721bc3f9b9ea96c58eca.png)

See [Report Schedules | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-schedules#parameters-tab) 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.
