Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Location
    Minnesota
    Posts
    6

    Unanswered: Finding years from listed date.

    Hi all, I need some help. I'm trying to make a query display the amount of years from the stated date in an entry. Heres an example

    [EntryDate] | Years From Date
    5/27/1988 | 23.xxx

    I've put in

    Years From Date: date() - [EntryDate] / 365

    and it gives me these outputs in the 40,000s. Although Some of the entries are in the future not all of them are though and they all output around 40,000. Can anyone give me an Idea of what to do?

    Edit: 9:34 PM 1/30/2010; Forgot part of the code.

  2. #2
    Join Date
    Jan 2010
    Location
    Minnesota
    Posts
    6
    Well, I figured out my problem I needed to put Parentheses around a section. Like this:

    Years From Date: (date() - [EntryDate]) / 365

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Thanks for taking the time to come back and post the solution. That's always appreciated by the next folks that come along and have a similar issue.

    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
  •