Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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. 

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question