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
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. 
Joe Micciche
Progressive Insurance