SETFILTER on a variable

mfh

Hello,

In a dataport I have one Data Item 'Sales Shipment Line'. A variable 'gDatorderDate' gives me the "Order Date" from the Sales Shipment Header (code on the OnbeforeExportRecord):

IF gRecSalesShipmentHeader.GET("Sales Shipment Line"."Document No.") THEN
  gDatOrderDate := gRecSalesShipmentHeader."Order Date";

I want to limit the results of the dataport output to records in a specific date range (01.05.06..30.04.07). Can I set a filter to this gDateOrderDate? How?

kriki

Try this:

gRecSalesShipmentHeader.GET("Sales Shipment Line"."Document No.");
IF (gRecSalesShipmentHeader."Order Date" < DMY2DATE(1,5,2006)) OR
    (gRecSalesShipmentHeader."Order Date" > DMY2DATE(30,4,2007)) THEN
  CurrDataport.SKIP;

mfh

kriki wrote:

Try this:

gRecSalesShipmentHeader.GET("Sales Shipment Line"."Document No.");
IF (gRecSalesShipmentHeader."Order Date" < DMY2DATE(1,5,2006)) OR
    (gRecSalesShipmentHeader."Order Date" > DMY2DATE(30,4,2007)) THEN
  CurrDataport.SKIP;

Perfect Alain! Thanks en de groeten,
Michiel