>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?
If I understood it correctly :
ldStart = {^1998/12/01}
ldEnd = {^1999/11/30}
do while ldStart <= ldEnd
if !seek(ldStart,"myTable","myDateTag")
endif
ldStart = ldStart + 1
enddo
Cetin