Filter Expressions - Ts

Example

#each of these time based dimensions can be filtered same way as ___time
#b.delivered___date:
#b.delivered___hour:
#b.delivered___hour2:
#b.delivered___hour3:
#b.delivered___hour4:
#b.delivered___hour6:
#b.delivered___hour8:
#b.delivered___hour12:
#b.delivered___minute:
#b.delivered___minute2:
#b.delivered___minute3:
#b.delivered___minute5:
#b.delivered___minute10:
#b.delivered___minute15:
#b.delivered___minute30:
#b.delivered___month:
#b.delivered___quarter:
#b.delivered___week:
#b.delivered___year:

b.delivered___time:
- 'any'
#on (year)/(month)/(day) (hour):(minute)
- 'on 2016/07/16 10:52'         #on 10:52 minute of 2016/07/16
- 'on 2016/07/16 10'            #on 10 hour of 2016/07/16
- 'on 2016/07/16'               #on 2016/07/16 day
- 'on 2016/07'                  #in July 2016 month
- 'on 2016'                     #in 2016 year

#on (year)/(month)/(day) (hour):(minute)
#to (year)/(month)/(day) (hour):(minute)
- 'on 2016/07/16 10:52    to 2017/08/22 17:32'
- 'on 2016/07/16 10       to 2017/08/22 17'
- 'on 2016/07/16          to 2017/08/22'
- 'on 2016/07             to 2017/08'
- 'on 2016                to 2017'

### 'before' can be replaced with 'after' in each example ###

#(before|after) (date time)
- 'before 2016/07/16 10:52'               
- 'before 2016/07/16 10'                  #same as "before 2016/07/16 10:00"
- 'before 2016/07/16'                     #same as "before 2016/07/16 00:00"
- 'before 2016/07'                        #same as "before 2016/07/01 00:00"
- 'before 2016'                           #same as "before 2016/01/01 00:00"

#(before|after) (date time) for (integer) (units)
- 'before 2016/07/16 10:52    for 2 years'
- 'before 2016/07/16 10       for 2 quarters'
- 'before 2016/07/16          for 2 months'
- 'before 2016/07             for 2 weeks'
- 'before 2016                for 2 days'

#(before|after) (integer) (units) [complete] (ago|in future)
- 'before 5 days ago'
- 'before 5 days complete ago'
- 'before 5 days in future'
- 'before 5 days complete in future'

#(before|after) (integer) (units) [complete] (ago|in future) for (integer) (units)
- 'before 5 days ago                for 2 hours'
- 'before 5 days complete ago       for 2 minutes'
- 'before 5 days in future          for 2 minutes'
- 'before 5 days complete in future for 2 minutes'

#last (integer) (units) [complete [plus current]]
- 'last 5 days'
- 'last 5 days complete'
- 'last 5 days complete plus current'

#[not] null
- 'null'
- 'not null'