# Ignition Report: Getting 1st day and last day of the month

**URL:** <https://forum.inductiveautomation.com/t/ignition-report-getting-1st-day-and-last-day-of-the-month/19745>\
**Category:** Ignition\
**Created:** [September 20, 2018, 4:19am UTC](https://forum.inductiveautomation.com/t/ignition-report-getting-1st-day-and-last-day-of-the-month/19745 "2018-09-20T04:19:35Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 20, 2018, 3:20pm UTC](https://forum.inductiveautomation.com/t/ignition-report-getting-1st-day-and-last-day-of-the-month/19745/3 "2018-09-20T15:20:56Z")

</div>

First day of month:

```auto
getDate(
	getYear({date}),
	getMonth({date}),
	1
)

```

Last day of month:

```auto
addDays(
	getDate(
		getYear({date}),
		getMonth({date}) + 1,
		1
	),
	-1
)

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/ignition-report-getting-1st-day-and-last-day-of-the-month/19745)._