Difference between revisions of "Filter by Date"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 13: | Line 13: | ||
::;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]] | ||
:::; | :::;Current Period Options: | ||
:::;This Month:First day of this month through today (inclusive) | :::;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 | :::;This Week:Sunday through Saturday; Optionally, choose '''Custom | Last | 7 | Calendar Day(s)''' to view the last 7 days of data | ||
Line 19: | Line 19: | ||
:::;Tomorrow:Includes all records in the 24 hour period from 12:00 am (00:00) to 11:59 pm (23:59) tomorrow | :::;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 | :::;Yesterday:Includes all records in the 24 hour period from 12:00 am (00:00) to 11:59 pm (23:59) yesterday | ||
:Click '''[Add Date Filter]''' for additional date filter rows. | ::Click '''[Add Date Filter]''' for additional date-filter rows. |
Revision as of 19:11, 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 Period Options
- 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
- Click [Add Date Filter] for additional date-filter rows.