Date: Fri, 29 Mar 2024 12:21:35 +0000 (UTC) Message-ID: <1124654529.12119.1711714895591@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_12118_1393841139.1711714895590" ------=_Part_12118_1393841139.1711714895590 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The LastDayOfMonth function takes a date/time value and returns another = date time value, equal to the last day of the month in the supplied date. T= his can be useful when combined with the FirstDayOfMonth function to get re= sults for a single months date range.
LastDa= yOfMonth(datetime)
Entity= Type =3D Incident AND LastUpdatedAt >=3D FirstDayOfMonth(DateSubtract(Now(), "4 weeks"))= =20 AND LastUpdatedAt <=3D LastDayOfMonth(DateSubtract(Now(), "4 weeks"))=20