Search BETWEEN dates?

Has anyone modified any version of RT to be able to search BETWEEN dates?

We can search for Created or Resolved Before, After, On dates. We need to
be able to search for just a specific month to generate our monthly
reports, e.g. Created between jan 01 2005 and jan 31 2005. We’re using
stock RT date fields. Or any other workarounds to get data for just one
month?

We’re on 3.0.7_01 going to 3.2.3 this week. TIA.

Joe Micciche
Progressive Insurance

Has anyone modified any version of RT to be able to search BETWEEN dates?

We can search for Created or Resolved Before, After, On dates. We need to
be able to search for just a specific month to generate our monthly
reports, e.g. Created between jan 01 2005 and jan 31 2005. We’re using
stock RT date fields. Or any other workarounds to get data for just one
month?

We’re on 3.0.7_01 going to 3.2.3 this week. TIA.

Did you try using AND?

DATE > 20050131 AND DATE < 20050131

Has anyone modified any version of RT to be able to search BETWEEN dates?

We can search for Created or Resolved Before, After, On dates. We need to
be able to search for just a specific month to generate our monthly
reports, e.g. Created between jan 01 2005 and jan 31 2005. We’re using
stock RT date fields. Or any other workarounds to get data for just one
month?

We’re on 3.0.7_01 going to 3.2.3 this week. TIA.

Did you try using AND?

DATE > 20050131 AND DATE < 20050131

There is no way to do this that I can see when using the web interface.
There is only a single date field in the query tool, and it offers Before,
After, On.

Joe Micciche
Progressive Insurance

Has anyone modified any version of RT to be able to search BETWEEN dates?

We can search for Created or Resolved Before, After, On dates. We need to
be able to search for just a specific month to generate our monthly
reports, e.g. Created between jan 01 2005 and jan 31 2005. We’re using
stock RT date fields. Or any other workarounds to get data for just one
month?

We’re on 3.0.7_01 going to 3.2.3 this week. TIA.

Did you try using AND?

DATE > 20050131 AND DATE < 20050131


There is no way to do this that I can see when using the web interface.
There is only a single date field in the query tool, and it offers Before,
After, On.

Uhhh… You and the date field twice, one with After and once with Before.
By default the interface will AND them together.

There is no way to do this that I can see when using the web
interface. There is only a single date field in the query tool, and it
offers Before, After, On.

When I have to do this, I search twice:

  • the first search filters after the start of the range

    • any other search criteria is also filled in with this search
  • then the second search filters before the end of the range

This ends up working fine, though it’s a pain to have to make a two step
process out of it.

If you’re clever, you can hand-code the URL to do what you want, but
I’ve never gotten this to work right with RT3, but I used to use it all
the time with RT2.

Chris Devers

Has anyone modified any version of RT to be able to search BETWEEN dates?

We can search for Created or Resolved Before, After, On dates. We need to
be able to search for just a specific month to generate our monthly
reports, e.g. Created between jan 01 2005 and jan 31 2005. We’re using
stock RT date fields. Or any other workarounds to get data for just one
month?

We’re on 3.0.7_01 going to 3.2.3 this week. TIA.

Did you try using AND?

DATE > 20050131 AND DATE < 20050131


There is no way to do this that I can see when using the web interface.
There is only a single date field in the query tool, and it offers Before,
After, On.

You can do DATE > 20050131 AND DATE < 20050131 with the web interface
by:

1.) Created Before 20050131
2.) Create After 20050101

However, I am not sure if it will be inclusive of those two dates. So,
you can try by adding the following to Advanced and see it in the Query
Builder:

Created = ‘20050101’ OR Created = ‘20050131’ OR ( Created > '20050101’
AND Created < ‘20050131’ )

Anthony Leong

However, I am not sure if it will be inclusive of those two dates. So,
you can try by adding the following to Advanced and see it in the Query
Builder:

Created = ‘20050101’ OR Created = ‘20050131’ OR ( Created > '20050101’
AND Created < ‘20050131’ )

Anthony Leong

It’s not. The query porbably needs to be:

Created > ‘20041231’ AND Created < ‘20050201’

There is no way to do this that I can see when using the web
interface. There is only a single date field in the query tool, and it
offers Before, After, On.

When I have to do this, I search twice:

  • the first search filters after the start of the range

  • any other search criteria is also filled in with this search

  • then the second search filters before the end of the range

This ends up working fine, though it’s a pain to have to make a two step
process out of it.

If you’re clever, you can hand-code the URL to do what you want, but
I’ve never gotten this to work right with RT3, but I used to use it all
the time with RT2.

Thanks Chris. While cumbersome, this does indeed work. I’m not clever
enough to handcode the url, evidenced by asking this question in the first
place. :wink:

Joe Micciche
Progressive Insurance