thanks for the answers! But the thing is more difficult than this ;-)
My filter, unnecessarily complicated as it might be, seems to not be the issue: I have now loaded the data once again with the filter in place - just as it was - and again, I find one record from December of last year and every day of this year - I even find events on the day I am looking for - only that specific record is missing.
I'll try to explain the process behind it:
- What I am generally looking for in this step of the script is receiving_bookings (when we receive goods, a booking to the database takes place which has the code SPRECEIVE, a timestamp and an item_number.
- This archiving_logic is built into our primary data_loading script (one step before the report I have built, so to speak)
- There is no filter on item_numbers, only on the date - start of last year like I said.
- As I said, I can find the day that that particular SPRECEIVE-booking took place - what I cannot find is that particular item_number.
<=> However, there is only one filter, so logically that is the only point_of_failure in the logic, so I will start by simplifying my filter - that Date-function was there before (in a LOAD of the current table which was there before I started on this), so I will not mess with that for a start - only it could be that the comparison-thingy of my filter does not match the outcome ... Let's see.