you can use a custom sql report, as mentioned above. but you don't need to install the datefield plugin. The datefield plugin is valuable. however, what you are trying to do has been done with sql and date functions:
see this thread: http://groups.google.com/group/trac-users/browse_thread/thread/c3452e8656af5988/62c9ebdee6ec91ea?hl=en&lnk=gst&q=datetime#62c9ebdee6ec91ea It has a few different types of date based reports for you. closed the last month, closed THIS month..etc. I believe they are SQLlite examples, no guarantees on postgres or mysql. one of these is looking for tickets that transitioned to closed between 2 dates. The dates in this thread are hardcoded, but could be supplied as part of the url to the report to dynamic variables. in your case, you would only need half the equations the greater than date X part. Rather then between. you would send the date to the report by appending it to the report url like so: YourProjectPath/report/18?DATEONE=2009-03-24 or something, might have to escape for urls assuming you used DATEONE as your variable. then in place of the hardcoded date you just put DATEONE. The "downside" of this is if you click on the actual report link in "view tickets" it bonks, since you need to provide the dynamic variable. It's easy to provide the variable as part of a wiki link however. if you wanted to auto-fill in the date form a selection, you'd need a custom form, or template, or maybe something that uses the datepicker javascript plugin thingy with some custom page/template- fu somehow. I'm sure it's easy for people that understand css and templates etc. I just embed it as a link on a wiki page :D hope this helps. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
