SETFILTER on a variable

mfh
mfh Member Posts: 28
edited 2007-07-05 in NAV/Navision Classic Client
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?
Regards,
Michiel

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    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;
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • mfh
    mfh Member Posts: 28
    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
    Regards,
    Michiel

Categories