>Thanks Hilmar
>
>Colin
I think Sergey is right. ttoc(MyDateTime, 1) is supposed to be used in indices; it will ensure that the same format is always used. Just use the same expression in seek().
It will also save you space in your index.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)