You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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.




EntityType = Incident
AND LastUpdatedAt >= FirstDayOfMonth(DateSubtract(Now(), "4 weeks")) 
AND LastUpdatedAt <= LastDayOfMonth(DateSubtract(Now(), "4 weeks")) 

See Also

  • No labels