Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    New Salem, North Dakota, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add 5 years to date (2000)

    I have a field that is formatted as a date field....mm/dd/yyyy.
    In a query I am trying to add 5 years to the date....can anyone help me...
    I can not get the syntax correct.
    Thanks!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: add 5 years to date (2000)

    In an empty column in the query grid, enter something like this:

    <code>FiveYearsLater: DateAdd("yyyy", 5, [NameOfDateField])</code>

    Replace NameOfDateField with the name of your date field, and FiveYearsLater with the name you want the calculated column to have.

Posting Permissions

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