I just had one done literally 2 weeks before my surgery. They actually couldn't finish because it was too painful. I need deep sedation; not just twilight sleep. They said I didn't have to repeat for 5 years, but I question that. Colonoscopies are not that bad; it is the prep that really sucks.
Good luck!!