2 Replies Latest reply: Mar 8, 2011 9:25 AM by Anne Duffy RSS

    Load between dates

      Hi Guys

      This is probably and easy question, but I just cant figure it out ,

      I'm loading Excel Spreadsheets into QV, but I wish to only load dates less than today and greater than 6th March 2010.

      I have tried :

       

       

       

       

       

       

       





       

       

      FROM

      [S:\Business Support\MASTER LOG\Master Logs (IN USE).xls]

       

      (biff, embedded labels, header is 1 lines, table is Drawdown$)

      WHERE

       

       

      Date<Date(Today()) and Date>Date(06/03/2010)

       

       





      But this is just bringing in all data before Today ( without the 6/3/10 restriction).

      I have the dates formated as :

       

       

       

       

       

       

       

      Date(Date) as Date

      Month(Date(Date)) as Month

      Week

       



      (Date(Date)) as Week

      Year(Date(Date)) as Year



      Can anyone please help ? Thanks