According to Jim

The Six-Week Curse (7x15)

Air date: May 13, 2008

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.