View source for Filter by Date

Date filters provide the ability to search records containing date-formatted fields.

A selection of dynamic date ranges are available, based on either a calendar period (This Month, Last Month), or on a number of day (Last 60 days, Last 120 days).

:[[file:filterbydate.gif|none|thumb]]

:;Parameters:Choose the date field and date range from the dropdown lists. The available fields will change, depending on the date fields that are included in the object. 

:;Field:Choose a Date Field for use in this filter
:;Choose the date range type:
::;Fixed:Specify a Start Date and and End Date (inclusive); Optionally, enter dates or use the Calendar button
::;Dynamic:Many options exist for Days, Weeks, Months, Quarters and Years, including both future and past dates; Optionally, choose a [[Custom Date Range]]

:::;Current:
::::;This Month:First day of this month through today (inclusive)
::::;This Week:Sunday through Saturday; Optionally, choose '''Custom | Last | 7 | Calendar Day(s)''' to view the last 7 days of data
::::;Today:Includes all records, from 12:00 am (00:00) to the current time
::::;Tomorrow:Includes all records in the 24 hour period from 12:00 am (00:00) to  11:59 pm (23:59) tomorrow
::::;Yesterday:Includes all records in the 24 hour period from 12:00 am (00:00) to  11:59 pm (23:59) yesterday

:::;Previous:
::::Many options are available, including 30-, 60-, 90-, 120-, and 365-day periods.

:::;Next:
::::Many options are available, including 30-, 60-, 90-, 120-, and 365-day periods.

:::;Calendar (quarter):
::::Options for current, previous, and next quarter, plus combinations.

:::;Calendar (year):
::::Options for current, previous, and next year, plus combinations.

:::;Financial:
::::Current Period, Next Period, and Previous Period
::::''Learn more:'' [[Financial Periods]]

:::;Custom:
::::Specify a cut-off date range to includes: 
::::: '''Before, After''', or in the '''Next'''
::::: '''{some number}''' of
::::: '''Calendar Days, Weeks, Months''', or '''Years'''

::Click '''[Add Date Filter]''' for additional date-filter rows.