Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    80

    Unanswered: Help! Specifying current year in a query criterion?

    It's me again!!

    Just wondering if there's an expression that can be used as a query criterion to denote the current year, without relying on any other expression like DatePart, etc. For example, you know how =Date() tells you the current date, =Time() tells you the current time, and so forth? I need something similar, except for just the year (in "yyyy") format, so that my query will only return, in the report, a list of menu items added to the menu during the current year. I suppose something as simple as =Year() is too much too hope for - I tried that but Access didn't seem to like it.

    Thanks for all assistance

    Grace

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Year requires an argument of date/time format. If you pass it the date function, you'll get the current year.

    year(date)
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •