You are here: Excel > Excel Code Writer (DLXFIND) > Set up the Range > Date Span

Date Span

 

A date span is used in Excel to set the data retrieval. Use the Date Span Wizard in the DLXRanger to create the date span. It consists of a start date and an end date. There are two types of date spans, a dynamic date span and a fixed date span.

 

How to Open DLXRanger

If you have Microsoft Office Excel 2007 or later first select Add-Ins

ClosedCreate the Date Span

Follow these steps and example to create a date span using the Date Span Wizard:

  1. Open the DLX Ranger > Date Span Wizard

  2. Select the Date Frequency and Start Date:

  3. Select the End Date by first choosing a Date Type:
    • If Dynamic, which allows the spreadsheet to be updated with current data in the future, select the Dynamic Format:

    • If Fixed, select the specific End Date:

    • (Optional) Select Range Options for additional options:

      • Data Options includes options that handle observations that are not available:
        • Interpolate - estimates values for NAs
        • Replace NAs - substitutes values for NAs with any number/text you enter
        • Remove NAs - removes rows or columns with NAs (uses the first series in the retrieval as an anchor)
        • Disaggregation - displays series of different frequencies in the same range
        • Magnitude - displays all retrieved data in the specified magnitude
      • Date Order
        • Ascending - begins the retrieval with the start date at the top
        • Descending - begins the retrieval with the latest date at the top

  4. Choose the Date Format:

  5. Choose the Style:
    • If All numeric was chosen, select the 2-digit or 4-digit year style:

    • If Alphabetic was chosen, select the 2-digit or 4-digit year style followed by the format:

  6. The date span created will appear in the date span window as shown below:

This date span was created by selecting a start date of January 2004, a dynamic end date for this month, and the alphabetic date format shown.

ClosedModify the Date Span

When the date span has already been created on a spreadsheet, it can be modified by using the DLX Date Wizard.

  1. Right click on the cell that contains the date span
  2. Select DLX Date Wizard
  3. Make the desired changes
  4. Proceed with a retrieval