Nope it does not. I see no scientific reason why it should. The moon is merely a gigantic rock held by Earth's gravity. In turn, it own gravity controls the tides. The only thing that may affects a person's mood is the moon's gravity, but even then there's no evidence to suggest that.