I'm getting a conversion error when I try to do a locate with two date
fields and two datetime fields:

ElevateDB Error #1011 An error occurred with the value 0000-00-00
00:00 (A conversion error occurred)

I checked the values and none of them is null or otherwise odd
(3/06/09,3/06/09 11:00:00 AM,3/06/09 11:30:00 AM,3/06/09).

I saw a related thread on 9/14/08. But all variables used in the
Locate are TDateTimes. In the table the date fields are date and not
timestamp.

Michael,

<< I'm getting a conversion error when I try to do a locate with two date
fields and two datetime fields:

ElevateDB Error #1011 An error occurred with the value 0000-00-00 00:00 (A
conversion error occurred)

I checked the values and none of them is null or otherwise odd
(3/06/09,3/06/09 11:00:00 AM,3/06/09 11:30:00 AM,3/06/09).

I saw a related thread on 9/14/08. But all variables used in the Locate are
TDateTimes. In the table the date fields are date and not timestamp. >>

Please send me an example of this and I'll take a look.  I suspect that
you're assigning something incorrectly, but I can't say for sure without
running your code.

--
Tim Young
Elevate Software
www.elevatesoft.com