on 01-09-2015 2:47 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.