Function: LastDayOfMonth
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. This can be useful when combined with the FirstDayOfMonth function to get results for a single months date range.
Syntax
LastDayOfMonth(datetime)
Example
EntityType = Incident AND LastUpdatedAt >= FirstDayOfMonth(DateSubtract(Now(), "4 weeks")) AND LastUpdatedAt <= LastDayOfMonth(DateSubtract(Now(), "4 weeks"))