Welcome to SPN

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

Sign Up Now!

Date

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

Tags:
  1. Ashkan D

    Ashkan D
    Expand Collapse
    Guest

    how can i define days between two date?
     
  2. Loading...

    Similar Threads Forum Date
    Self Update On The Gurdwara Blogs Apr 3, 2017
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Sikh News Sikh Candidate In Hamilton Disgusted By Racist Vandalism - Newstalk ZB Breaking News Aug 22, 2016
    Sikh News Amit Jani: Trump Leverages Fear In Americans, Wrong Candidate For Our Nation's Future Breaking News Feb 18, 2016
    Update Blogs Oct 16, 2015

  3. OP
    Dennis

    Dennis
    Expand Collapse
    Guest

    Use the DateDiff function

    DateDiff("d",[StartDate],[EndDate])

    "Ashkan D" wrote:

    > how can i define days between two date?
     
  4. OP
    fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 14 Jun 2006 01:40:02 -0700, Ashkan D wrote:

    > how can i define days between two date?


    [Date1] - [Date2]
    or
    DateDiff("d",[Date1],[Date2])
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  5. OP
    SusanV

    SusanV
    Expand Collapse
    Guest

    Use between. For example, for all records between June 1 2005 and June 1
    2006, the where clause would be:

    WHERE ((YourTable.YourDateField) Between #6/1/2005# And #6/1/2006#);
    --
    hth,
    SusanV



    "fredg" <fgutkind@example.invalid> wrote in message
    news:bm404dm68um7.1l9og1mfv7vpm.dlg@40tude.net...
    > On Wed, 14 Jun 2006 01:40:02 -0700, Ashkan D wrote:
    >
    >> how can i define days between two date?

    >
    > [Date1] - [Date2]
    > or
    > DateDiff("d",[Date1],[Date2])
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page