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

Compare with Current View Page History

Version 1 Current »

Function: FirstDayOfMonth

The FirstDayOfMonth function takes a date/time value and returns another date time value, equal to the first day of the month in the supplied date. This can be useful when combined with the LastDayOfMonth function to get results for a single month date range.

Syntax

FirstDayMonth(datetime)

Example

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

See Also

  • No labels