Hi all

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