Re: [rt-users] relative date search

2015-03-05 Thread Alex Peters
You can enter 14 days ago into the Created box, or

Created  14 days ago

into the Advanced screen of the search builder.

On Fri, 6 Mar 2015 5:47 pm Eierschmalz, Bernhard 
bernhard.eierschm...@scheppach.com wrote:

  Hello,



 is it possible to make date-searches in RT with relative date?

 For example search all open tickets where creation-date is older than 14
 days.





 best regards

 Bernhard



[rt-users] relative date search

2015-03-05 Thread Eierschmalz, Bernhard
Hello,

is it possible to make date-searches in RT with relative date?
For example search all open tickets where creation-date is older than 14 days.


best regards
Bernhard


Re: [rt-users] relative date search

2015-03-05 Thread Alex Peters
Here's all of the acceptable syntax:

https://metacpan.org/pod/Time::ParseDate#Relative-date-formats

On Fri, 6 Mar 2015 5:48 pm Alex Peters a...@peters.net wrote:

 You can enter 14 days ago into the Created box, or

 Created  14 days ago

 into the Advanced screen of the search builder.

 On Fri, 6 Mar 2015 5:47 pm Eierschmalz, Bernhard 
 bernhard.eierschm...@scheppach.com wrote:

  Hello,



 is it possible to make date-searches in RT with relative date?

 For example search all open tickets where creation-date is older than 14
 days.





 best regards

 Bernhard




[rt-users] Relative Date Search Help - current week(end)?

2014-02-18 Thread drhamilton11
Currently on RT 4.0.12 

Doing a custom search and could use some help.  We are using a custom search
field (date/time) and trying to do a search for anything for the current
weekend.  Tried using logic such as 'friday after last' and other things,
but no luck. 

Trying to set up some dashboards so when viewed, it'll show tickets for the
current weekend.  Best I got so far was  'last sunday' AND  'next monday'. 
That at least shows the current week, but I need ONLY the weekend. 

Thanks in advance!



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training


Re: [rt-users] Relative Date Search Help - current week(end)?

2014-02-18 Thread Gareth Dawson
Why not just next Saturday or next Sunday

On 18 Feb 2014 15:39, drhamilton11 drhamilto...@hotmail.com wrote:

 Currently on RT 4.0.12 

 Doing a custom search and could use some help.  We are using a custom search 
 field (date/time) and trying to do a search for anything for the current 
 weekend.  Tried using logic such as 'friday after last' and other things, 
 but no luck. 

 Trying to set up some dashboards so when viewed, it'll show tickets for the 
 current weekend.  Best I got so far was  'last sunday' AND  'next monday'. 
 That at least shows the current week, but I need ONLY the weekend. 

 Thanks in advance! 



 -- 
 View this message in context: 
 http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688.html
  
 Sent from the Request Tracker - User mailing list archive at Nabble.com. 
 -- 
 RT Training London, March 19-20 and Dallas May 20-21 
 http://bestpractical.com/training 
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training

Re: [rt-users] Relative Date Search Help - current week(end)?

2014-02-18 Thread drhamilton11
That will not work because viewing the search on Friday will show the
following weekend's tickets, not the current weekend.  

Anyone else have any suggestions?  Thanks!



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688p56698.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training


Re: [rt-users] Relative Date Search Help - current week(end)?

2014-02-18 Thread Kevin Falcone
On Tue, Feb 18, 2014 at 07:39:41AM -0800, drhamilton11 wrote:
 Doing a custom search and could use some help.  We are using a custom search
 field (date/time) and trying to do a search for anything for the current
 weekend.  Tried using logic such as 'friday after last' and other things,
 but no luck. 
 
 Trying to set up some dashboards so when viewed, it'll show tickets for the
 current weekend.  Best I got so far was  'last sunday' AND  'next monday'. 
 That at least shows the current week, but I need ONLY the weekend. 

We use this module
https://metacpan.org/pod/Time::ParseDate#DATE-FORMATS-RECOGNIZED

That's what is supports.

You may want to play with
http://bestpractical.com/docs/rt/latest/RT_Config.html#AmbiguousDayInPast-AmbiguousDayInFuture

-kevin


pgpEHIoggvs5m.pgp
Description: PGP signature
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training

Re: [rt-users] Relative Date Search Help - current week(end)?

2014-02-18 Thread drhamilton11
Still looking for help on this.  I can't seem to get the logic.

Again, if I want to set up a dashboard showing what ticket are due THIS
COMING Fri/Sat/Sun - is that possible?

It can flip on Sunday, that would be fine.  

The problem with searches like after next thursday and before next monday,
is that on that thursday, it would display the week ahead of the current.

There's gotta be some backward logic that'll make this work.  Thanks!



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688p56710.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training