I have a field that has a date in it. I need to change the year to the current year, while keeping the month and day. I'm looking to do this in a query.
I want to convert 7/16/1968 to 7/16/2008
Any help would be great.
thanks
I have a field that has a date in it. I need to change the year to the current year, while keeping the month and day. I'm looking to do this in a query.
I want to convert 7/16/1968 to 7/16/2008
Any help would be great.
thanks
I figured it out, and it works with date calculations:
[CSD] is the date I was trying to convert to the current year
full: DatePart("m",[csd]) & "/" & DatePart("d",[csd]) & "/" & DatePart("yyyy",Date())