Search

Searching in Clubhouse: Dates and Date Ranges

You can search for Stories and Epics using dates and date ranges in the Navigational Search Bar or for Stories only on the Search page using the operators below.

Date Formatting

First, it's important to use the correct date formatting in your searches. The format Clubhouse recognizes is 4 digit year-2 digit month-2 digit day: 

YYYY-MM-DD

When searching for a date range, separate your dates with two periods:

YYYY-MM-DD..YYYY-MM-DD

You can make your date range open-ended (or unbounded, in search parlance) by adding an asterisk (*) on one side of the range. 

An asterisk on the left side of the date range would find you all Stories or Epics before the specified date:

*..YYYY-MM-DD

And an asterisk on the right side of the date range would find you all Stories or Epics after the specified date: 

YYYY-MM-DD..*

You can also search using the terms yesterday and today, as well as tomorrow (but this latter term can only be used when searching for due dates, more on this below).

Please note that numerical date values and date terms currently can't be mixed -- so a search for '2018-04-01..today' wouldn't work, for example.

Date-Based Operators

Created
Updated
Moved
Started
Completed
Due

You can search for Stories and Epics that have been created, updated, and completed using a specified date or date range, or the terms yesterday or today.

You can also search for Stories and Epics that are (or were) due on a specified date or date range, or using the terms yesterday, today, or tomorrow.

Created

created:2018-05-22

Search_for_Stories_Created_on_a_Specified_Date.png

Search_for_Epic_by_Created_Date_in_Clubhouse.png

Updated

The updated operator will find Stories or Epics that last had changes or additions made to it on or within the specific time period (i.e., changes in description, comments, state, due date, Project, Epic, etc.).

Note: When using the updated: operator, keep in mind that it asks "What Stories or Epics were last updated on/before/after this date or within this date range?"

updated:today

Search_for_Stories_Updated_Today.png

Find_Epics_by_Updated_Today.png

Moved

The moved operator will only find Stories that have changed workflow state (i.e., those which have "moved" to a different workflow state column) on or within a specified time period.

Note: This operator will currently only find Stories; Epics are not supported.

moved:*..2016-11-17

Search_for_Stories_Moved_Using_an_Unbounded_Date_Range.png

Started

started:2018-01-01..2019-01-01

Find_Stories_by_Started_on_Search_Page.png

Find_Epics_Started_in_a_Date_Range.png

Completed

completed:2018-04-01..2018-05-22

Searching_for_Stories_Completed_in_a_Date_Range.png

Find_Completed_Epics_by_Date_Range.png

Due

due:tomorrow

Searching_for_Stories_Due_Tomorrow.png

Find_Epics_Due_Tomorrow_in_Clubhouse.png

Have more questions? Submit a request