How do I specify a date range in a report

[HGrigsby]

Hi 

I am sure this is easy but ... I need to run a report to give me all tickets logged between two dates.  It needs to run on a overnight to go into Power BI so cannot select the dates option.   

I need to find all tickets  DateLogged between 02/11/2020 & 04/02/2020 OR DateModified between 02/11/2020 & 04/02/2020

but I keep coming up with 0 results

Can anyone help me out?   I am sure it is obvious but I can't find the right way to do it

Thanks 

Helen 

[Victor]

@HGrigsby can you post a screenshot with the filter please?

[HGrigsby]

Hi Victor

Sorry for the delay - I had all sorts of filters but couldn't get any to work.   

I just don't know how to specify between dates can do start of week month, last quarter, last 10 days etc but not 

between two specified dates.  I just don't know how to write the criteria 

Helen

 

[Victor]

@HGrigsby can do it two way basically, details for each below:

1. using a filter with two criterions, date logged greater than AND date logged less than.
Example of a filter for date logged after Jan 1st and before Feb 1st. The date is specified as YYYY-MM-DD HH:MM:SS

 

2. using a filter with one criterion, date logged between two date values. 
Example of a filter for date logged between Jan 1st and Feb 1st. The date is specified as YYYY-MM-DD HH:MM:SS

 

If you need to filter on an additional column then the "between" filter is more simple, as you only need to add a second criterion, like the first with an OR operator (depends if the result is inclusive or exclusive). The "greater than, less than" filter is slightly more complicated as you need to cater for operator precedence, meaning you need to enclose certain criteria in brackets, again, depending how the result is inclusive or exclusive.

For example, request raised between 02/11/2020 and 04/02/2021 OR modified between 02/11/2020 and 04/02/2021:

First type of filter would have this criteria:

(Date Logged > 2020-11-02 00:00:00 AND Date Logged < 2021-02-04 00:00:00) OR (Date Modified > 2020-11-02 00:00:00 AND Date Modified < 2021-02-04 00:00:00)

Note the operators and use of brackets and remember to use the date format specified above when building the report.

Second type of filter would have this criteria:

Date Logged BETWEEN '2020-11-02 00:00:00' AND '2021-02-04 00:00:00' OR Date Modified BETWEEN '2020-11-02 00:00:00' AND '2021-02-04 00:00:00'

Note the brackets are not required (but can be used) and remember to use the date format specified above when building the report..