SQL problem
Hi everybody
I would like to thank everybody who helped me in solving the
problem.
The statement which Rudy Fernandes sent me worked excellent.
unload to gunluk_rapor
select gun,ay,yil,shipperaccount,airwaybill,consignee_code,cons_iata,
cons_zipcode,cons_countrycode,exception_msg
from tarih_ayrilmis
where "20" || shipmentdate[1,2] =year(today-1)
and shipmentdate[3,4] =month(today-)
and shipmentdate[5,6] =day(today-1);
Special thanks to Rudy...