Skip to Content
0
Jul 31, 2019 at 06:48 AM

Select date entered by user

40 Views

Hello,

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]