Date/Time a ticket is closed

[BradWilcox]

If I want to know all of the tickets that were closed in a certain timeframe, what field would I look at in the database?

[Karel_DS]

You'll have to look at the date column in htblhistory, specifically the last entry where typeid = 1 and ticketstateid = 1, if the row exists for a ticket.