Results 1 to 2 of 2
  1. #1
    fdnyfish is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2005
    Posts
    3

    Changing a date to the current year

    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

  2. #2
    fdnyfish is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2005
    Posts
    3
    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())

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-13-2008, 09:55 AM
  2. Retrieving Week of Year in a date range
    By Korvega in forum Queries
    Replies: 2
    Last Post: 05-27-2006, 06:29 AM
  3. Finding data between two date for any year
    By gemini2 in forum Access
    Replies: 4
    Last Post: 04-05-2006, 06:20 AM
  4. Mailmerge Current Record...
    By oakleyp2 in forum Programming
    Replies: 0
    Last Post: 02-22-2006, 08:08 AM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums