SELECT <otherfields>, tstjv.jvdate AS billdate, <morefields>, {} AS stockdate, .....and I already had a SELECT that did some more manipulations so I changed it a wee bit
SELECT <otherfields>, asdfg.billdate, <morefields>, IIF(EMPTY(asdfg.stockdate), asdfg.billdate, asdfg.stockdate)) AS stockdate, .....Thanks.