[rt-users] Find the first day of this month

2015-12-08 Thread Chris Herrmann
Hi all, This has been kicked around a few times over the years if google & the list archives are anything to go on, but I haven't actually seen a solution that meets what any of the requestors (and me) want. Which is... to run a search using a date like: Queue = 'myqueue' and ( ( Status =

Re: [rt-users] Find the first day of this month

2015-12-08 Thread Chris Herrmann
I also looked at the Attributes table, but the actual SavedSearch is stored as a binary blob AFAICT? I was going to head down the path of updating the contents of the field with a programmatically generated string once a day or something like that: queue = "myqueue" and Created > "2015-12-01"

Re: [rt-users] Find the first day of this month

2015-12-08 Thread Christian Loos
Hi Chris, won't help you now but RT 4.4.0 will support this if you set $PreferDateTimeFormatNatural to 1: https://github.com/bestpractical/rt/commit/4836a20 If you really need this in RT 4.2 you can try applying these commits: https://github.com/bestpractical/rt/commit/f446755