Welcome to SPN

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

Sign Up Now!

last three months date query

Discussion in 'Information Technology' started by msmuzila@gmail.com, Jul 28, 2006.

  1. msmuzila@gmail.com

    msmuzila@gmail.com
    Expand Collapse
    Guest

    what would the criteria be for a query where i want the filter the
    SHIP_DATE field for the last three months
     
  2. Loading...

    Similar Threads Forum Date
    Last Blog Blogs Oct 14, 2016
    That Pesky Last 1% Blogs Oct 12, 2016
    Self Songs Of The Last 10 Years Blogs Oct 2, 2016
    Difficult Areas Of Turban And How To Remedy It ? Is A Plastic Cup For Your Ears The Answer Health & Nutrition Jun 4, 2016
    Alone At Last Blogs May 1, 2016

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On 19 Jun 2006 18:52:53 -0700, msmuzila@gmail.com wrote:

    >what would the criteria be for a query where i want the filter the
    >SHIP_DATE field for the last three months


    BETWEEN DateAdd("m", -3, Date() AND Date()

    will get the range from April 19 through June 19.

    John W. Vinson[MVP]
     

Share This Page