Hi Naomi,

Thanks - Sergey did point that out earlier.
I was really trying to figure out the reason behind the phantom record, more than how to incorporate the time into an index expression.
(If I know the root cause, I can avoid the pitfall in the future)


>Hi Ashley,
>
>According to http://msdn2.microsoft.com/en-us/library/8e15e2zs(VS.80).aspx you should use TTOC(Start,1) in your index expression. Note the second parameter of TTOC.
>
>
>
>>Hi Sergey,
>>
>>Right!! mea culpa.. and thanks.
>>However, the STRTRAN(SUBSTR(TTOC(START),12,5),":"), while not as elegant or efficient as RIGHT(TTOC(start,1),6), should have worked.
>>Also, even though my time(start) yielded the wrong result, neither expression explains the phantom record phenomena to me.
>>As the time part was not essential, I removed it, and it seems to have resolved the issue. I was just curious as to whether anyone had a explanation for the phantom occurrence.
>>
>>Rgds
>>