Query for tickets created last month

Try this:

        Created>='1st day last month' 
    AND Created<='1st day this month'