The Six Week Curse

S7 E15: Dana puts Andy under hypnosis to learn why all of his relationships don't last longer than six weeks; Dana decides to boost up Andy's confidence but ends up making things worse when Andy starts flirting with other women while on a date with Emily.