How long should you wait to get your nose re-pierced if you tried to pierce it yourself and only got the needle halfway through?

Let it heal over completely. While its healing, rinse the area with a sea salt and water mixture- a pinch of natural sea salt in a shot glass of warm water- to prevent infection. Once it's completely closed, go see a piercer :)