# Schedule a transaction group monthly

**URL:** <https://forum.inductiveautomation.com/t/schedule-a-transaction-group-monthly/11370>\
**Category:** Ignition\
**Created:** [March 16, 2016, 4:02pm UTC](https://forum.inductiveautomation.com/t/schedule-a-transaction-group-monthly/11370 "2016-03-16T16:02:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RClem](https://avatars.discourse-cdn.com/v4/letter/r/50afbb/32.png) [@RClem](https://forum.inductiveautomation.com/u/RClem)\
**Post date:** [March 16, 2016, 4:02pm UTC](https://forum.inductiveautomation.com/t/schedule-a-transaction-group-monthly/11370/1 "2016-03-16T16:02:15Z")

</div>

I’m using Ignition 7.7.0 with MySQL 5.6 and I’m looking to trigger a transaction group on the first of every month. I am using 3 triggered expression items to total nine gas totals in to a monthly total. I have the MySQL query worked out and tested, but I can’t determine how to trigger or schedule this on the first of every month.

Rich

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 16, 2016, 5:28pm UTC](https://forum.inductiveautomation.com/t/schedule-a-transaction-group-monthly/11370/2 "2016-03-16T17:28:32Z")

</div>

Hi Rich,

A quick and dirty way would be to make a Run-Always Expression Item to use as a trigger:

```auto
dateExtract(now(),'day') = 1
```

I usually name mine “Trigger”… 🙂

You can then set things up in the trigger tab of the transaction group:  
[attachment=0]2016-03-16\_13-23-05.jpg[/attachment]

---

<div class="post-metadata">

**Author:** ![RClem](https://avatars.discourse-cdn.com/v4/letter/r/50afbb/32.png) [@RClem](https://forum.inductiveautomation.com/u/RClem)\
**Post date:** [March 16, 2016, 5:33pm UTC](https://forum.inductiveautomation.com/t/schedule-a-transaction-group-monthly/11370/3 "2016-03-16T17:33:17Z")

</div>

I wasn’t sure if that would work or not, I’ll give it try.

Thanks,  
Rich