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


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

Share This Page