Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Adding Years to a Date

Discussion in 'Information Technology' started by Jose Aleman, Jul 28, 2006.

Tags:
  1. Jose Aleman

    Jose Aleman
    Expand Collapse
    Guest

    Hi,

    I wanted to add two years to a date column.
    Example:
    07/01/06 = 07/01/08

    Does anyone know how to do this?
     
  2. Loading...

    Similar Threads Forum Date
    Self Songs Of The Last 10 Years Blogs Oct 2, 2016
    Sikh News Manjusha P. Kulkarni: Where Are We Fifteen Years After 9/11: A Look At A Decade And A Half Breaking News Sep 11, 2016
    Sikh News 15 Years After 9/11 Founding, The Sikh Coalition Builds A 'Path Forward' Breaking News Sep 10, 2016
    June 1984 - 31 Years Later, Sikhs Remember Hard Talk Jun 3, 2015
    Khalsa Aid Khalsa Aid - 16 Years Of Service To Humanity Sikh Organisations Apr 5, 2015

  3. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi.

    Use the DateAdd function:

    DateAdd("yyyy",2,[DateField])

    -Michael



    "Jose Aleman" wrote:

    > Hi,
    >
    > I wanted to add two years to a date column.
    > Example:
    > 07/01/06 = 07/01/08
    >
    > Does anyone know how to do this?
     
  4. Paul Overway

    Paul Overway
    Expand Collapse
    Guest

    NewDate = DateSerial(Year(OldDate)+2,Month(OldDate),Day(OldDate))

    --
    Paul Overway
    Logico Solutions, LLC
    www.logico-solutions.com


    "Jose Aleman" <JoseAleman@discussions.microsoft.com> wrote in message
    news:0D11341E-5072-48C1-BD95-B5BC55EE62A6@microsoft.com...
    > Hi,
    >
    > I wanted to add two years to a date column.
    > Example:
    > 07/01/06 = 07/01/08
    >
    > Does anyone know how to do this?
     
  5. Jose Aleman

    Jose Aleman
    Expand Collapse
    Guest

    Thanks Mike.

    I just had finished reading the previous post when you responded.

    Thank You very much

    "Michael H" wrote:

    > Hi.
    >
    > Use the DateAdd function:
    >
    > DateAdd("yyyy",2,[DateField])
    >
    > -Michael
    >
    >
    >
    > "Jose Aleman" wrote:
    >
    > > Hi,
    > >
    > > I wanted to add two years to a date column.
    > > Example:
    > > 07/01/06 = 07/01/08
    > >
    > > Does anyone know how to do this?
     
  6. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Jose Aleman wrote:
    > Hi,
    >
    > I wanted to add two years to a date column.
    > Example:
    > 07/01/06 = 07/01/08
    >
    > Does anyone know how to do this?


    There is a DateAdd() function.

    DateAdd("yyyy", 2, [YourDateField])

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page