Welcome to SPN

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

Sign Up Now!

Relative Dates

Discussion in 'Information Technology' started by Thomas, Nov 3, 2005.

Tags:
  1. Thomas

    Thomas
    Expand Collapse
    Guest

    How do I query by relative date (for example, -1 for yesterday)
     
  2. Loading...

    Similar Threads Forum Date
    Everything is relative Blogs Oct 17, 2015
    Politics Suffragette Emmeline Pankhurst Relative On Women's Rights Breaking News Oct 27, 2012
    Canada Jassi Sidhu’s relatives denied bail ahead of extradition hearing Breaking News Mar 1, 2012
    Controversial PM issues apology to relatives of Air India victims Hard Talk Jun 24, 2010
    Sikh News Sad News As Distant Relative Shot To Death On Last Day Of Work Breaking News Mar 20, 2010

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    =Date()-1


    --
    Rick B



    "Thomas" <Thomas@discussions.microsoft.com> wrote in message
    news:12BA6AC4-03FF-47F2-8BE2-CC8F46D1213B@microsoft.com...
    > How do I query by relative date (for example, -1 for yesterday)
     
  4. Bob Miller

    Bob Miller
    Expand Collapse
    Guest

    place Date()-1 in criteria for the date field
    Thomas Wrote:
    > How do I query by relative date (for example, -1 for yesterday)



    --
    Bob Miller
     

Share This Page