>It's been a hectic day in two differnt RDBMS apps, so forgive the silly question, I'm nearing brain dead.
>I need to batch update a group of records. There are two date field, start_date, end_date. Start_date is easy, it gets DATE() or a user selected date as a value. End_date, however needs to be EXACTLY 10 years later. DATE()+3650 does not account for leap years, nor does DATE()+3653, allthough it works for this year. Is there a quick way to add 10 years? I have been looking through the help files and cannot find a reff to adding years, only minites, sec, hours and days.
You could use GOMONTH
GOMONTH(DATE(), 12 * 10)
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers