Hey to everyone.Here's the problem: I need to display something that I think mathematically looks like this:
STATUS_DATE < MOV_DATE < STATUS_OK_UNTIL
Details : As it appears all 3 are date fields that belong to separate linked tables. I need to show all records that have a MOV_DATE between the STATUS_DATE and the STATUS_OK_UNTIL date. Problem is I need the STATUS to be ok when a movement occurs... I seem not to get right results e.g. on the same day I have different status for the same code (the status field can change on a single day from one situation to another but on that day no movement occurs), and I can't get Last of in the expression....
Any clues?
Hope I am clear enough....
STATUS_DATE < MOV_DATE < STATUS_OK_UNTIL
Details : As it appears all 3 are date fields that belong to separate linked tables. I need to show all records that have a MOV_DATE between the STATUS_DATE and the STATUS_OK_UNTIL date. Problem is I need the STATUS to be ok when a movement occurs... I seem not to get right results e.g. on the same day I have different status for the same code (the status field can change on a single day from one situation to another but on that day no movement occurs), and I can't get Last of in the expression....
Any clues?
Hope I am clear enough....
Last edited:
