Martin,

I'll assume that your main data table has a field called TranDate

Essentially, I'd populate a cursor with all the dates in the range and then find what's missing from the main table.

I'll hard-code the dates you've used below

CREATE CURSOR DateRange (TranDate D)
FOR nOffset = 0 to ({^1999-11-30} - {^1998-12-01} - 1)
   INSERT INTO DateRange VALUES ({^1998-12-01} + nOffset) 
ENDFOR

SELECT DateRange.TranDate ;
  FROM DateRange ;
  WHERE DateRange.TranDate NOT IN (SELECT DISTINCT TranDate FROM MainDataTable) ;
  INTO ...

Cheers,

Andrew

>I need to create a query that will return mssing dates within a range.
>e.g. Between the 01/12/1998 and 30/11/1999 - say there is no data for the first two weeks of december 98. I need to know which dates are missing to run a routine to 'patch' in this mssing data from dates that do contain data.
>
>Any ideas?