>Hi All:
> I have a datetime field and I want to change the year to 2002. How can I accomplish this?
> I.E. 05/25/2001 5:25:23P.M. needs to be 05/25/2002 5:25:23 P.M.
GOMONTH() accepts either a date or a datetime argument, so trivially:
REPLACE DateTimeFld WITH GOMONTH(DateTimeField,12)
This also side-steps what to do with February 29th...