[AccessD] A2K Increase Year by 1

That was it 
Thanks Demulling Family



----- Original Message ----- 
From: "Demulling Family" <demulling at centurytel.net>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Monday, April 05, 2004 9:24 AM
Subject: Re: [AccessD] A2K Increase Year by 1


> Darren DICK wrote:
> 
> >Hello all
> >Brain fade here
> >It's Monday morning and everything is just as you would expect a Monday to be <sigh>
> >I have a dB that holds dates of Occurrences
> >I have a  need to increase the 'year' portion only of that date by 1
> >eg 31/01/2001 now needs to become 31/01/2002
> >There are hundreds of 'em though so doing it manually isn't an option.
> >I just need a quick query to update 'em all. I actually have done this is the past 
> >(on the same dB actually) but can't recall how I did it <sigh>
> >
> >Many thanks in advance
> >
> >Darren
> >
> >  
> >
> DateAdd("yyyy",1,<<your date>>)
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com