All,

Has anyone run into this one:

VFP 6.0 SP5

I have a table with an id (Id) and a date (dDate). I try to order the date by id and by date descending. I use the following index:

Id + str({^2100-12-31} - dDate,5,0)

I get an "Index does not match table" message. When I look at the index expression I see:

"id+STR({12/31/2100}-ddate,5,0)"

It seems VFP tables do not understand the STRICT date format.

BTW, Id + STR(CTOD("12/31/2100")-ddate,5,0) works fine.

Thanks

Rex