Has anybody been hypnotised in order to forget an event before? does it work?

there's just a lot i'd like to forget. i wanted to know if it actually can work? has anybody has it done on them before? i'm slightly skeptical but i'd like more information on how it works and if the effects are long lasting. thanks for any help!