A spike aerator is better if you are not laying down fertilizer or seed. But either will work. You want to do it before it rains if you are using a plug style... otherwise you will have little plugs everywhere for a while....
Earlier the better. The fall is a good time too.