The Rockies certainly are amazing.
They are mostly snow covered year round so I would think from June to mid/end August would be the warmest time. Maybe a little later but it depends on if your just going to day hike or overnight.