Hi
Kindly request your assistance to sort out the values in SAP B1 Query generator.
/*SELECT FROM [dbo].[ORCT] p1*/
declare @FROM as Date
declare @TO as Date
/* WHERE */
set @FROM = /* p1.docdate */ '[%0]'
set @TO = /* p1.docdate */ '[%1]'
----------------------------------------------------------------------
select ORCT.DocNum As 'Receipt Num' ,ORCT.DocDate AS 'Receipt Date'
from ORCT
where ORCT.NoDocSum<>0
AND ORCT.DocDate>=@FROM
AND ORCT.DocDate<=@TO
order by ORCT.DocNum
-------------------------------------------
Here above I have declared two parameters " @FROM as Date and @TO
The query is running OK and just need to know whether there is any method to sort these two DATES when it is being prompted in form .
Thanks