The XBRL Date Selector assists quick application of XBRL dates by providing commonly used Fiscal dates separately from non-fiscal Other dates.
The fiscal view of the XBRL Date Selector presents fiscal dates/date ranges for a selected year and quarter. The dates/date ranges shown on the fiscal view are provided from the XBRL fiscal calendar, which must be filled out for the selected years prior to use of the XBRL Date Selector. When you select a fiscal date, the XBRL Date Selector will automatically create the XBRL date for you if it does not exist in your account. You can not manually add a fiscal date/date range.
To help you find the date you want more quickly, there are three date filters and one search option available on the Other dates view in the XBRL Date Selector. These filters are listed at the top of the XBRL Date Selector window.
The Duration, Instant, and In Doc filters will appear with a blue box when turned on and gray when turned off. To turn these filters on and off, simply click on the filter you would like to apply.
- Filter Duration dates. When this filter is turned on, only XBRL dates that have a period type of Duration will be shown in the date list.
- Filter Instant dates. When this filter is turned on, only XBRL dates that have a period type of Instant will be shown in the date list.
- Filter In Doc dates. When this filter is turned on, only XBRL dates that are used in the document will be shown in the date list. This filter can be used in conjunction with the Duration or Instant filters for more specific results. This filter is on by default when you use the XBRL Date Selector.
You can also type a specific date into the search field or use the calendar drop-down and select a specific date to show only XBRL dates containing the inputted date in the date list.
Applying a Fiscal XBRL Date
- With XBRL turned on, click on the link or cell for which you would like to apply an XBRL date.
- Select Search Dates/Date Ranges in the XBRL Detail Tagging window.
- On the Fiscal view of the XBRL Date Selector, ensure the Reporting Period is correctly identified by using the year and quarter drop-down menus. Verify that the dates shown include the date you want to tag.
- For the selected year-quarter combination, the fiscal view of the XBRL Date Selector will show QTD, YTD, and As Of dates for the current year, prior year, and two years prior. The As Of dates will show the currently selected quarter-end date and the previous two year end dates.
- Select the applicable date and then select Apply. You can also double-click to select and apply the date. If no fiscal calendar data is detected, you will be prompted to fill out your Fiscal Calendar before using the XBRL Date Selector.
If you are trying to apply a date/date range that isn't appearing in the XBRL Date Selector, you can select Update Fiscal Calendar in the top-right corner of the fiscal view of the XBRL Date Selector to access your fiscal calendar. The fiscal view of the XBRL Date Selector will automatically provide the date/date ranges needed once the applicable quarter end dates are added to the XBRL Fiscal Calendar.
Applying an Other XBRL Date
- With XBRL turned on, click on the link or cell which you would like to apply a date.
- Select Search Dates/Date Ranges on the XBRL Detail Tagging window.
- On the XBRL Date Selector, access the Other dates view by selecting the Other button in the top-left of the window.
- Find and select the applicable date from the list of Other dates and click the Apply button.
Adding an Other XBRL Date
If you need to apply a non-fiscal XBRL date that does not appear in the Other date list, you can create a custom Other XBRL date.
- On the Other dates view of the XBRL Date Selector, select Add Date in the top-right corner.
- This launches the Add Date window:
- On the add/edit date window, select either Instant or Duration from the period type drop-down. The period type of the custom date needs to match the period type of the concept that will be used for the fact. Instant dates are as of a single day at 24:00 hours. Duration dates are for a range of time from 00:00 to 24:00 hours and can be for one day or more than one day.
- Input the desired date or date range by selecting the calendar icon or simply typing in a date in the Period Dates fields.
- Type in the applicable Fiscal Year that applies to the chosen date/date range. Select a fiscal quarter from the Fiscal Quarter drop-down. Fiscal Quarter should match the fiscal quarter of the date or date range in step 3.
- Provide an annotation for the date ID. Standard annotations are available by using the drop-down menu on the annotation input field. You can create a custom annotation by simply typing the desired annotation into the annotation input field.
NOTE: Best practice is to use a standard method of date annotations with three letters for the month and two digits for day(s). As an example, for an instant date annotation, it is recommended to provide an annotation of Dec29 for an Other date of 12/29/2015 which will then show as I2015Q4Dec29. For a duration date annotation, it is recommended to provide an annotation of Dec2029 for a date range of 12/20/2015 through 12/29/2015 which will show as D201Q1Dec20-29.
- Click the Save button. Saving the date will automatically apply it to the XBRL fact. This adds the new custom, non-fiscal Other XBRL date to your Other dates list.
NOTE: You can edit/deprecate a previously created Other date by selecting the Pencil icon next to the date. This is not available when you are replacing a date.
Deprecating an Other Date
Deprecating an XBRL date enables you to remove a non-fiscal Other date that should not be used from the Other dates list.
If you deprecate an XBRL date that is used in XBRL facts in your document, you will receive document check messages when you run doc check which identify the fact and recommend that you replace the deprecated date with another active date.
You may file with deprecated XBRL dates, however it is a best practice that all deprecated dates applied to XBRL facts be replaced with active dates. Deprecating a date removes it from your account, and therefore will affect previous filings. If you need to refile a document, it is recommended to follow step 6 below and replace any deprecated dates applied to XBRL facts with active dates.
To deprecate a non-fiscal Other XBRL date:
- On the Other dates view of the XBRL Date Selector, select the Pencil icon next to the date you would like to deprecate.
- This opens the Edit Date window. Select the Deprecate (i.e. - should not be used) button.
- A confirmation window is displayed. If you are sure you want to deprecate the XBRL date, click Yes.
- On the XBRL Date Selector, click Cancel.
- To find all deprecated XBRL dates on the active document, go to the XBRL tab, click the Validate drop-down, and select Document Check.
- After Document Check finishes, verify if there are messages that read "Fact is using a deprecated date that should be replaced". A message will be provided for each instance of the deprecated date used in the document. You can double-click on the Document Check message to activate the location finder to locate the fact using the deprecated date in the document. Replace the deprecated date by selecting the date drop-down in the XBRL Detail Tagging Window and selecting Replace. Use the XBRL Date Selector to select an active date.
- Share XBRL by clicking on the Share button on the XBRL tab of the toolbar.