>Yes, k_date is a date field. I tried the ff.:
>
>select * from kdata where k_date >= '09/01/1999'
>select * from kdata where k_date >= '09/01/99'
>select * from kdata where k_date >= {09/01/99}
>select * from kdata where k_date >= {09/01/1999}
>select * from kdata where k_date >= '{09/01/1999}'
>select * from kdata where k_date >= {'09/01/1999'}
>
>all this does not work.
>
>Ramon Carlos
>
>>
>>Is Kdata a date field or a char field?
>>
>>If its a date field then try
>>db_qry = db_qry & " where k_date >={" & Date_From & "}"
>>
>>Jeff
We must be missing something! This should work just fine. I'm doing the same thing here and it works. Could you e-mail me a small part of you dbf and your asp. Let me try it here.
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com