Skip to Content
avatar image
Former Member

Date range parameters in a query

Hello Experts,

Could someone explain to me how to prompt for a date range in any particular query that i build?  New to the query game but if i can understand how to do this properly it would help me greatly.  Thanks in advance. 

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 09, 2015 at 04:58 PM

    Hi,

         Welcome to the Query Game 😊,  to prompt a date range in a query we have to write the condition in Where Clause see the below Example for a Sales Order Documents Total Doc No wise

    select a.DocDate,A.DOCNUM,A.DocTotal

    from ORDR A

    Where A.DocDate>= '20141201'  and A.DocDate<='20141231'

    so in above Query we put the parameters

    Select a.DocDate,A.DOCNUM,A.DocTotal

    from ORDR A

    Where A.DocDate>= [%0]  and A.DocDate<=[%1]

    Hope it will help you😊.

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thanks Manich,

           Had to put T0. in place of the A. put it looks like this will do the trick!