Difference between revisions of "Filter by Date"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Date filters provide the ability to search records containing date-formatted fields. | Date filters provide the ability to search records containing date-formatted fields. | ||
A selection of dynamic date ranges | A selection of dynamic date ranges is available, based on either a calendar period (This Month, Last Month), or on a number of days (Last 60 days, Last 120 days). | ||
:[[file:filterbydate.gif|none|thumb]] | :[[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. | :;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. | ||
Line 10: | Line 9: | ||
:;Field:Choose a Date Field for use in this filter | :;Field:Choose a Date Field for use in this filter | ||
:;Choose the date range type: | :;Choose the date range type: | ||
::;Fixed:Specify a Start Date | ::;Fixed:Specify a Start Date 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]] | ::;Dynamic:Many options exist for Days, Weeks, Months, Quarters and Years, including both future and past dates; Optionally, choose a [[Custom Date Range]] | ||
Line 37: | Line 36: | ||
:::;Custom: | :::;Custom: | ||
:::: | ::::Specify a cut-off date range. The choices include: | ||
::::: '''Before, After''', or in the '''Next''' | |||
::::: '''{some number}''' of | |||
::::: '''Calendar Days, Weeks, Months''', or '''Years''' | |||
::Click '''[Add Date Filter]''' for additional date-filter rows. | ::Click '''[Add Date Filter]''' for additional date-filter rows. |
Latest revision as of 20:39, 25 July 2014
Date filters provide the ability to search records containing date-formatted fields.
A selection of dynamic date ranges is available, based on either a calendar period (This Month, Last Month), or on a number of days (Last 60 days, Last 120 days).
- 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 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. The choices include:
- Before, After, or in the Next
- {some number} of
- Calendar Days, Weeks, Months, or Years
- Click [Add Date Filter] for additional date-filter rows.