Hypnosis can be used to motivate someone. It’s not a magic pill which can just inject ‘motivation’ into your life, but it can certainly help you uncover and access your motivation, if you work with a competent hypnotist.
However, if you’re thinking of tapes that play trancy music and say ”you can do it!” over and over again, then no, those aren’t so good.
The approach must be tailored to you personally for good results because we all are motivated by different things in life. So see a good hypnotist near you for proper results and you’ll get better access to your ‘get up and go.’