Good Afternoon, here is what I am trying to do.
I have a 2006 Calendar, and a date field formated as follows:
Tuesday, September 4 , 2006.
What I would like to do is run a query that will automatically update the date field to 2007, ie- Tuesday, September 3, 2007.
I tried this by using a -1 against the date field. It gives me the correct Day and Month, However, it does not change the year.
Does anyone have a suggestion? Any help is greatly appreciated.
Thanks
I have a 2006 Calendar, and a date field formated as follows:
Tuesday, September 4 , 2006.
What I would like to do is run a query that will automatically update the date field to 2007, ie- Tuesday, September 3, 2007.
I tried this by using a -1 against the date field. It gives me the correct Day and Month, However, it does not change the year.
Does anyone have a suggestion? Any help is greatly appreciated.
Thanks