>Wow, I've been doing it different for years. Is there something wrong
>with the code below that I've been using?

No, that's pretty good too. I'd just change it to use the DATE(year, month, day) function instead of building the date as a string, but that's just me.