cancel
Showing results for 
Search instead for 
Did you mean: 

Date range parameters in a query

Former Member
0 Kudos

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. 

Accepted Solutions (1)

Accepted Solutions (1)

former_member184146
Active Contributor
0 Kudos

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

Former Member
0 Kudos

thanks Manich,

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

Answers (0)