>The code depends on SET DATE AMERICAN to be in effect. It'll produce incorrect resut or blow up with other settings. It's better to use DATE() function. Also YEAR() function requires an argument.

Yes -- you are correct. Guess it was on 1-1/2 cents worth... :)

Also, I think it would be better to use your version rather than Borislav's version. Having the year as a parameter input would be better to account for a leap year. Otherwise, it is always assuming the current year rather than any possible year.