We want to thank you all again for the great fun last weekend.

(In this sentence, what does 'last weekend' modify?)

It's an adverbial phrase, telling when the "great fun" happened. Seems odd, I know, but sometimes colloquial speech is not easily explained by the rules of standard English!