Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

FILTER OPTION NOT WORKING

former_member902308
Member

‎2023 Mar 21 11:24 AM

0 Kudos
222
  • SAP Managed Tags:
  • SQL

DECLARE FromDate Date;

DECLARE ToDate Date;

FromDate:=/*select Min(T0.DocDate) from "ORCT" T0*/'[%0]';

ToDate:=/*select Max(T0.DocDate) from "ORCT" T0*/ '[%1]';

SELECT T0."DocDate",T0."DocNum", T0."CardCode", T0."CardName", T0."TrsfrAcct", T0."TrsfrSum", T0."Ref1", T0."Ref2", T0."Comments", T0."JrnlMemo", T0."TransId", T0."BoeNum", T0."PayToCode"

FROM ORCT T0;

1 REPLY 1

SonTran
Active Contributor

‎2023 Mar 21 12:31 PM

0 Kudos
102
  • SAP Managed Tags:
  • SQL

Hi,

You miss the WHERE clause, try this:

DECLARE FromDate Date;

DECLARE ToDate Date;

FromDate:=/*select Min(T0.DocDate) from "ORCT" T0*/'[%0]';

ToDate:=/*select Max(T0.DocDate) from "ORCT" T0*/ '[%1]';

SELECT T0."DocDate",T0."DocNum", T0."CardCode", T0."CardName", T0."TrsfrAcct", T0."TrsfrSum", T0."Ref1", T0."Ref2", T0."Comments", T0."JrnlMemo", T0."TransId", T0."BoeNum", T0."PayToCode"

FROM ORCT T0
WHERE T0."DocDate" between :FromDate and :ToDate;

Hope this helps,

Son Tran

Hope this helps,
Son Tran