LastDayOfMonth

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")) 

See Also