July 3rd we had red flags, but the water was still very pretty. The 4th saw yellow flags and the 5th regained the red status that we still have.
It definately fluctuates. Prior to this though we had numerous consecutive days with green and yellow flags, very calm and inviting conditions. Nature is at the helm though. Good luck.
Btw, plan for alternatives. I guess making sand castles on red flag days, running in and out of the oncoming waves up on the shore, trying not to let them 'get you'. Walking trails, shopping, surfing, throwing frisbee. I'm sure you'll find ways to smile and enjoy yourself.