Sounds kind of like a bad passive-aggressive kind of situation there to me... and from experience w/my husband & his family (look up passive-aggressive in the dictionary & there's a family picture of them!), I know p-a behavior.

I would try to talk it through, find out why he chose to work & make the weekend difficult instead of going out for a trip. Maybe he really is worried about money, or maybe he thought that instead of trying to find something that you would enjoy you were trying to make a grand compromise? Or maybe he's not feeling well or is tired & doesn't feel up to a long day?

Whatever happens, best of luck & hope you have a better date the next time around