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 | :::;Current: | ||
:::;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 | ||
:::;Today:Includes all records, from 12:00 am (00:00) to the current time | ::::;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 | ::::;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 | ||
:::;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. | |||
::Click '''[Add Date Filter]''' for additional date-filter rows. | ::Click '''[Add Date Filter]''' for additional date-filter rows. |
Revision as of 19:41, 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.
- Click [Add Date Filter] for additional date-filter rows.