2 Replies Latest reply: Feb 11, 2013 5:15 AM by Chris Young RSS

    Issues with selecting with date ranges?!

      I am trying to make a select from an ODBC connection using this select:

       

      SELECT TASK_ID, CANCELLED_DATE, CLOSED_TIME, CLOSED_DATE, DEADLINE_DATE, DEADLINE_TIME, DOCUMENT_TYPE, TASK_FAULT_CODE_ID, TASK_TYPE, X_OPEN

      FROM REP_TASK_NF WHERE DEADLINE_DATE BETWEEN $(FromDate) AND $(ToDate);

       

      $(FromDate) and $(ToDate) are both variables being used in a Calender Object.

       

      Am i going the right way about this or is the not the best way of going about this?

       

      Thanks