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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [email protected]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to