Welcome to SPN

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

Sign Up Now!

adding years to dates.

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

  1. rhys

    rhys
    Expand Collapse
    Guest

    Hi,
    Ihave a form which contains a calendar and two text boxes. When a date
    is clicked on the calendar it updates textbox1 with the date. I need
    textbox2 to automatically update with the same date but 3 years in advance.
    How do I do this. I know how to add minutes and hours on to a time but can't
    work out dates

    Rhys
     
  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.

    Search Access Help on the DateAdd function. You probably want to use it
    like this:

    DateAdd("yyyy", 3, "ControlName")

    -Michael



    "rhys" wrote:

    > Hi,
    > Ihave a form which contains a calendar and two text boxes. When a date
    > is clicked on the calendar it updates textbox1 with the date. I need
    > textbox2 to automatically update with the same date but 3 years in advance.
    > How do I do this. I know how to add minutes and hours on to a time but can't
    > work out dates
    >
    > Rhys
     
  4. rhys

    rhys
    Expand Collapse
    Guest

    thanks mate

    "Michael H" wrote:

    > Hi.
    >
    > Search Access Help on the DateAdd function. You probably want to use it
    > like this:
    >
    > DateAdd("yyyy", 3, "ControlName")
    >
    > -Michael
    >
    >
    >
    > "rhys" wrote:
    >
    > > Hi,
    > > Ihave a form which contains a calendar and two text boxes. When a date
    > > is clicked on the calendar it updates textbox1 with the date. I need
    > > textbox2 to automatically update with the same date but 3 years in advance.
    > > How do I do this. I know how to add minutes and hours on to a time but can't
    > > work out dates
    > >
    > > Rhys
     

Share This Page