Date update query

[Pheonix3077]

I'm trying to create a query where any date that is equal to or older than a year will be changed to reflect the next year. So a date that is 5/23/2003 will become 5/23/2004. Any ideas on how I would do this? thanks for the help.

 

[PHV]

Something like this ?
UPDATE myTable SET myDate=DateAdd("yyyy",1,myDate)
WHERE myDate<=DateAdd("yyyy",-1,Date())
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244