Creating a date from 3 variables?

[richnorris]

This feels like it should be so easy, but it just wont seem to give me the right results.

Basically,I have 3 variables.

vThisYear = max(year)

vThisMonth = max(month)

vThisDay = max(day)

why cant I go MakeDate($(vThisYear), $(vThisMonth), $(vThisDay)) ?

[richnorris]

Ok, sussed it, its because I have 4 years selected, and february. last year was a leap year, but this is not, so my max day in feb is 29, which is invalid for 2010. Pretty lucky I spotted that corner case!