Difference between revisions of "Filter by Date"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 36: | Line 36: | ||
:::;Custom: | :::;Custom: | ||
::::Define a custom date range | ::::Define a custom date range, specifying: | ||
::::: Before, After, or Next | |||
::::: (some number) of | |||
::::; Calendar Days, Weeks, Months, Years | |||
::Click '''[Add Date Filter]''' for additional date-filter rows. | ::Click '''[Add Date Filter]''' for additional date-filter rows. |
Revision as of 19:47, 24 April 2014
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).
- 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
- Define a custom date range, specifying:
- Before, After, or Next
- (some number) of
- Calendar Days, Weeks, Months, Years
- Click [Add Date Filter] for additional date-filter rows.