Welcome to SPN

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

Sign Up Now!

how we will find difference between two dates in MS Acess

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

  1. imran

    imran
    Expand Collapse
    Guest

    How we will find the difference between two date columns and difference will
    appear in third column.
     
  2. Loading...

    Similar Threads Forum Date
    Pathfinder Joins Sikh Philosophy Network! New SPN'ers Sep 5, 2016
    The Salmon Story, Finding Home Sikh Sikhi Sikhism Jul 29, 2016
    Sikhi Guru Nanak's Methodology Of Finding Truth Sikh Sikhi Sikhism Jan 1, 2016
    Movies Ashdoc's movie review---Finding Fanny ( English version ) Theatre, Movies & Cinema Sep 15, 2014
    Leisure Can someone pls help me find this Waheguru Simran...?? Business, Lifestyle & Leisure Aug 5, 2014

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 19 Jul 2006 08:34:03 -0700, imran wrote:

    > How we will find the difference between two date columns and difference will
    > appear in third column.


    In a query?
    DaysDifference:DateDiff("d",[DateField1],[DateField2])
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. imran

    imran
    Expand Collapse
    Guest

    Message is (entered an invalid identifier or typed parenthese)

    "fredg" wrote:

    > On Wed, 19 Jul 2006 08:34:03 -0700, imran wrote:
    >
    > > How we will find the difference between two date columns and difference will
    > > appear in third column.

    >
    > In a query?
    > DaysDifference:DateDiff("d",[DateField1],[DateField2])
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     

Share This Page