According to Jim - Season 7 Episode 15 -

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.