MS Access, Pulling the year from the date/time stamp

Discussion in 'OT Technology' started by FiveRivers, Aug 13, 2008.

  1. FiveRivers

    FiveRivers New Member

    Joined:
    Mar 3, 2008
    Messages:
    3
    Likes Received:
    0
    Hey guys,

    I'm building an access database and can't seem to find the answer I need, so I figure I will ask the community. The title pretty much explains it all... I need to pull the year out from the date/time stamp.

    An easy option I'm open to (if someone can tell me how) is making an expression in my query that will pull out the year from the date/time stamp.

    Thanks for your help in advance. :x:
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Uh... year([FieldName])
     
  3. FiveRivers

    FiveRivers New Member

    Joined:
    Mar 3, 2008
    Messages:
    3
    Likes Received:
    0
    HaHa... I knew it was something simple, I was trying something way more complicated than that. Thanks man.
     

Share This Page