[rt-users] Time between created and resolved

[Andres Altamirano]

Hi
I would like to know how to set a column in a query that shows the
time between the ticket was created an resolved.

Example:

Created  : 20090301
Resolved : 20090310
Between  : 9 days (hour, etc)

I've tried query builder in advance but can't find some functions that
i can use like in sql.

thanks,

-- 
Atte.
Andres Altamirano
Subdirección Innovación Tecnológica
Dirección de Informática
Pontificia Universidad Católica de Chile
Campus San Joaquin. Vicuña Mackena 4860
Fono: +56 2 3547183

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3200 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090428/c2b1381f/attachment.bin>