>Is the index on the date field based strictly on the field or is it >re-formatted a la DTOS() or some-such? > >*IF* it is basd on DTOS() or some-such, then some some-suches could. it >seems to me, yeild different results *IF* someone was able to change the >date format while your app is running. A re-index on a machine set with the >correct date format would fix the problem. > >This, of course, is all highly specilative. The main difference between DTOS() and DTOC() is that the first invariably returns yyyymmdd string, while the other returns various formats, depending on Set Date, so your reasoning might apply to DTOC().