If you're going to the pumpkin patch at the end of September (when some first open) the weather is usually sunny and in the low 70s. However, the weather in October is usually in the 50s-60s and either cloudy or rainy. The later you go in October, the bigger chance of rain and chilly weather so dress appropriately.