I would recommend to upgrade to VFP9 where it works fine. No reason to waste time on something so outdated.

>
>I have already worked around this problem but I find it too typical not to mention here. I am SELECTing and UNIONing a few table something like below:
>
>

SELECT <otherfields>, tnprc.billdate, <morefields>, tnprc.stockdate, .....
>   FROM a09tnprc tnprc ;
>...
>   INTO CURSOR asdfg
>...
>brow norm && all is well till here diff. dates for bill and stock dates
>
>SELECT * ;
>   FROM asdfg ;
>UNION ALL ;
>SELECT <otherfields>, tstjv.jvdate AS billdate, <morefields>, tstjv.jvdate AS stockdate, .....
>   FROM a09tstjv tstjv ;
>...
>   INTO CURSOR asdfg
>brow norm && when a09tstjv does not return records a09tnprc dates for billdate has become stock dates
>

>
>In the case where there are no records present for a09tstjv, the records pull for a09tnprc will have the same dates for billdate and stockdate when in actual they are different.
>
>Moving forward, for the time being I have {} AS stockdate and later I do an IIF and replace the empty stock dates with bill dates.
>
>Any idea why this might be happening