Can I Select the date entered By user ?
like [%1 ]this query
SELECT T3.[CardName], T3.[phone1], T3.[Address], Sum(T0.[SysDeb] - T0.[SYSCred]) as Credit,[%1] FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode INNER JOIN OJDT T2 ON T0.TransId = T2.TransId INNER JOIN OCRD T3 ON T3.[CardCODE]=T0.[ShortName] WHERE T0.[ShortName] = [%2] and T2.[RefDate] between '2017-01-01' and [%1] GROUP BY T3.[CardName],T3.[phone1],T3.[Address]
I want to Show the date entered by user [%1]