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]')*