When is the best time to go to a water park or pool to avoid crowds but still have warm weather?

Late May or early September is the sweet spot. May is usually warm enough for water play in most climates, and crowds are thin because school is still in session. Early September works too — kids are back in school, the weather is often still hot, and you avoid the holiday weekend rush. Late May is usually the safer bet for both warmth and emptiness.