>>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.
Also: if I understand correctly, all you need is a unique key expression. For this purpose, you may be better off using a primary key with an "auto-generated" integer value.
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)