Replacement motion detector light only works with neutral connected to ground

light

I'm trying to figure out what is wrong with the wiring going to my replacement garage outdoor fixture. I'm replacing an old burned out fixture and i just moved in so I don't know if it was bad to begin with. My issue is that the fixture only works when neutral is connected to ground which I know is wrong. I have 120v to the hot wire. What do I need to check to see how to fix it?

Thanks Ken

Best Answer

it turned out to be a loose neutral in a junction box. the second problem was they ran 12/4 from the switch box to the junction box and used the red wire as the second hot wire I'm guessing to save money and be cheap and this was done during construction so that made isolating and troubleshooting it more difficult.