Filter by Date Range

Help Center Get Answers
1

I need to be able to filter a table by a date range.  I don't see a way to do this and it seems so basic.  

Thanks for your help!

 

Lisa

2

378083664571 Would this work for you?

 

3

How could you accomplish this using a filter menu?

4

LIsa - 

in your table controls, 

Add Filters->

first filter:Date Before

second filter: Date After

5

Dear Lisa, you can achieve that using a combination of two date filters with an AND condition. The first will filter all dates after a certain date, the other all dates before a certain date. That's basically a range. This is valid for any type of range filtering you want to achieve

Example: date range between 1st January 2019 and 10 February 2019

FILTER 1: Date IS AFTER 31st December 2018
FILTER 2: Date IS BEFORE 11th February 2019

Hope this helps

Davide

6

Hi Lisa, do you mean a filter for dates between a start and end date?

7

Actually, it is quite easy. You just need two conditions: 

Date is before X

AND Date is after Y

Hope that helps.