Skip to Content
Former Member
Sep 06, 2010 at 03:40 PM

Query Parameter


Hi all,

I hava a query to run on SAP B1 Query Executer with a Date Parameter, so when i execute a query it should ask for the date parameter which the user will pick it up from the datetime picker.

But i find that the [%0] or any other [%..] variable is used for only the table's field.

so is there any possible way to do it.

i have some pseudo query like

*Select * from JDT1 T1 where T1.RefDate=GetLastDateOfMonth('[%0]')*