This has already been invented. It's called alcohol.

Scientists at work on a pill to fade traumatic memories

For over a decade, I have been erasing memories by drinking large quantities of alcohol. It not only suppresses traumatic memories, it also works on more trivial ones such as: "Where did I leave my car?" and "Why does my ass hurt and where are my pants?"