13 Replies Latest reply on Feb 4, 2007 9:13 PM by BKBK

    where between

    RyanG24 Level 1
      Hi i have a where clause with a between 2 dates

      WHERE ProfitDate Between #CreateODBCDateTime(Form.StartDate)# AND #CreateODBCDateTime(Form.FinishDate)#

      this works fine but i need the first date to be show aswell, so if a user chooses 12/12/2006 and 12/01/2007

      it will show item inbetween and including the dates, not sure how to do this