Hi.. i need your help,

I'm using baan 5.0c
I want to select a date from table tcccp020 - Maintain calendar Lines (main table is tdpur401).
I've create like the following script;

select tcccp020.date
from tcccp020
where tcccp020._index1 = {:tdpur401.odat}
selectdo
endselect
When I compile it's works fine no errorr.
but it doesn't work during execute the session (Print Pur. Order-Cust.). with the error "Illegal type to assigned to tdpur401, Expected [Number]".
I've convert the date to utc.to.local but facing the same problem.

Anyone can help me once more ????

I think that you should check your variable types and their values like whether it is number or date .

Good luck ...!

I think that you should check your variable types and their values like whether it is number or date .

Good luck ...!

I saw that The type of tcccp020.date is date, with domain tcccp.date (dd/mm/yyyy). But I compare using tdpur401.odat it's not matching.

Hi,

You need to convert the utc date format to local date format using the following

ret = utc.to.date(tdpur401.odat,yy,mo,dd,hh,mi,ss)

then you can compare the two