Hi All,

Is there any possibility to select record in report script which the date is passing from selection screen (SQL Query):
if yes, how to declare at delclaration for date.f and date.t

SQL Query:

where
tdpur401.odat >= tdpur401.odat.f and
tdpur401.odat <= tdpur401.odat.t and

Report Script:

select *
from tdpur204
where tdpur204.rqno = {:tdpur200.rqno}
and tdpur204.item = {:tdpur201.item}
and tdpur204.pono = {:tdpur201.pono}
and tdpur204.trdt between :date.f and :date.t
selectdo
endselect

Thank You.

Hi,

Check these 2 threads -

Thread 1 (http://www.baanboard.com/baanboard/showthread.php?t=62273)

Thread 2 (http://www.baanboard.com/baanboard/showthread.php?p=21611)

I don't think its possible. What are you trying to achieve? May be someone can suggest an alternative.