According to Jim: Season 7, Episode 15

7 - 15: The Six-Week Curse

Dana puts Andy under hypnosis to learn why all of his relationships don't last longer than six weeks. Upon learning that it's due to Andy's low self-esteem, Dana decides to boost up Andy's confidence, but she ends up making things worse when Andy starts flirting with other women while on a date with Emily.