Welcome to SPN

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

Sign Up Now!

Calculate Default Date in a Table

Discussion in 'Information Technology' started by SDH@DJ, Jul 28, 2006.

  1. SDH@DJ

    SDH@DJ
    Expand Collapse
    Guest

    I want to calculate a date to add 1 month from that date. For example, filed
    1 says 01/01/2006 and new date would be calculated into field 2 as 02/01/06.

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    India Reading Calculated Banis Breaking News Mar 6, 2013
    Islam Default 1500 years old Bible in which 'Jesus predictis coming of Muhammad' Interfaith Dialogues Feb 27, 2012
    1984 84 Sikh riots case: US court issues default certificate against Congress leader Kamal Nath History of Sikhism Aug 7, 2010
    Legal No protection to tenant after second default in payment: HC Breaking News Jul 19, 2010
    Sikh News Ministers, MLAs on Punjab loan default list (Hindustan Times) Breaking News Nov 26, 2007

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Very bad idea. You should seldom store derived data in a table. Instead you
    should calculated it needed in a form, report, or query.

    DateAdd("m", 1, #01/01/2006#) = 02/01/2006

    DateAdd("m", 1, [YourDateField])

    Be careful to know what you want for dates that are the 29th, 30th, or 31st
    of the month.

    DateAdd("m", 1, #31-Jan-06#) can not be 31-Feb-06 so Access makes it
    28-Feb-06.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "SDH@DJ" wrote:

    > I want to calculate a date to add 1 month from that date. For example, filed
    > 1 says 01/01/2006 and new date would be calculated into field 2 as 02/01/06.
    >
    > Thanks
     

Share This Page