Hi All: Does anyone have any knowledge of IF records (or any transaction records) being unable to be pulled after a 7 day period ( We are using SYSDATE to filter on) ? I'm unable to pull transactions older than 6/17. TIA!

How are you filtering?

if.lastmodifieddate > (SYSDATE - 10); It's only giving the through the 17th.

Have you adjusted that last number to something larger as a test? Like 50 or 100?

@Clay Roper yes, we did play with the number in the equation. Thanks!

Can you share the full query?

@Clay Roper sure: SELECT if.tranid as shipment_no, if.lastmodifieddate as ship_date, so.tranid as so_number, so.otherrefnum as po_number, BUILTIN.DF(if.trackingnumberlist) as tracking, shipping.shippingmethod as ship_method, item.itemid as item, line.quantity as quantity from transaction if join transactionline line on if.id = line.transaction join transaction so on so.id = line.createdfrom join item on line.item = item.id join transactionshipment shipping on if.id = shipping.doc WHERE line.itemtype = 'InvtPart' and line.quantity > 0 and if.lastmodifieddate > ( SYSDATE - 3)