How to Create Filters Using Date Questions

Introduction

By default, date/time questions in Q can't be used as filters on their own. this article describes how to create filters in Q using data from date/time questions.

Method

When creating filters, date questions have options that allow you to specify both fixed date periods (e.g., 1st of July 2014 to 31st of July 2014), and relative time periods (e.g., last 6 months, as illustrated below).

When using relative time periods, Q first aggregates the data and then computes the filter. 

1. From the toolbar, select Create > Variables and Questions > Variable(s) > Binary - Complicated Filter...
2. Select a data/time formatted variable
3. Specify the desired time frame, which in this example is the last 6 months.
   
4. Provide a name and label for the filter variable
5. Click OK.

Next

How to Create and Use Filters

How to Create Date Variables in Q