hi,
Actually the whole version is this way

select bhav_data
index on timestamp tag idxtime
set order to idxtime

create cursor test(t1 c(20),date d)

select bhav_data
scan
m.timestamp = bhav_data.timestamp
m.ld = convert_date(m.timestamp)
insert into test(t1,date) values(m.timestamp,m.ld)
endscan

select test
index on timestamp tag t1

select bhav_data
delete tag idxtime
replace date with test.date for seek(timestamp,'test','t1')

I tried using Sql here but was very slow in vfp6 and ideas how to speed this up ?

suhashegde