Filter By Date Parts or Date Field

To filter by a date part, use the WHERE clause with the EXTRACT() function, and pass it the desired date parts (year, month, or day). To filter by a date field, use the WHERE clause with a logical operator.

This example filters by year.

This example returns CloseDate fields that occur on or before the given timestamp.