[AccessD] A2K Increase Year by 1

John W. Colby jwcolby at colbyconsulting.com
Sun Apr 4 18:19:24 CDT 2004


DateAdd

JWC

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
Sent: Sunday, April 04, 2004 7:08 PM
To: AccessD List
Subject: [AccessD] A2K Increase Year by 1


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

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list