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