You absolutely can make it past two weeks. You just have to learn from experience and also reach out and find some community to keep you supported and accountable.
Have you ever started drinking again after some time off and it's gone well and you've been able to moderate and just have one drink and switch to tea and then wake up the next morning feeling all sparkly and fresh?
I'm guessing not. You probably wouldn't be wanting to quit if that was the case. You have more than likely picked up right where you left off and drank too much and it's been awful and you regretted it and you feel miserable and wish you hadn't. It's a learning experience though. You've done it and now you know. You don't have to keep trying to see if you can just have a couple drinks and it all be fine. Because you can't. It doesn't work. It won't work. People who have drinking problems don't just magically get better after a short break and go back to drinking 'normally' (whatever that means) with no regrets or consequences.
But you can't keep doing the same things over and over again and expecting a different outcome than before. So what can you do differently this time? There's two things I'd suggest you could try. One is to treat yourself like you are unwell and you need to recover from something that is making you poorly. How would you take care of yourself if you were recovering from a really bad stomach bug or from a bereavement? (I know these things are very different things - but it depends on if you need to heal more physically or emotionally or more likely both). If you were really trying to feel better after a really tough time, what would you prioritise? Stopping drinking isn't about abstaining from alcohol. It's about topping up your glass (never mind the pun!) and filling your life with stuff that is going to nourish you and not wear you down to the bones.
Honestly, I took a couple weeks off of work (this may not be possible, but it doesn't have to be), and I filled my days with reading, exercise, swimming, naps, etc. things I enjoyed. At times, I would have normally drank, I did other things - I took a class, I went to the cinema with my kids, I went for a run, sometimes I just went to bed. If you drink because you are meeting up with friends on a Friday, don't for a bit. I started taking a class on some Friday nights and I had to drive to it, so couldn't drink. Cancel stuff if you think you'll be tempted to drink if you go. Read some quit lit, go to bed early with a cup of herbal tea and read. Plan something for 6am on Saturday so you have to go to bed early and sober on Friday night.
And then reach out and find other people who are also quitting. There are lots of Stop for September things happening now. There are Facebook groups and loads of support networks out there. I belong to a group called Bee Sober (you can google them if you want) and they have a private Facebook group and lots of support. It's a really nice community where everyone is in the same boat and you can keep yourself accountable.
You probably know this already, but the first few weeks are the hardest bit. You're doing the hardest bit over and over again and never getting to the good easy bit. I'm 4 months now and honestly, I don't even think about drinking anymore. I've been to parties and BBQs and on holiday and did the summer school holidays and weekends away and honestly, it's totally fine. You will get there and it will be so much easier.