I would like to show using Ticketquery all closed tickets for the day only. I have the following query '[[TicketQuery(status=closed,owner=rrwithro|dmorales|hcpatel|pwmitche|adboatne|dbadmin,group=owner,order=priority,format=table,col=id|summary|priority|changetime)]]'
Whenever i put in changetime i get an integer error "".
That macro works fine in my Trac (after changing the user names, of course). What version of Trac are you running?
Does the Trac log show anything useful? If not, try increasing the log level to 'DEBUG' and see if any details get printed out.
Disable some or all of your Trac plugins and see if the behavior changes. It is possible that the error might be originating from one of them.
Also, does that query work in the normal ticket query interface (not the macro)? If so, you can save the query there and refer to it by number.