>>I mentioned it in my initial reply, but DTOC(< date >, 1) does exactly the same thing. The problem that I saw was the mention of the date fields being stored as strings. If they're ever coverted to dates, then the above is a workaround. The question is "Where's the most overhead"? Not knowing the format of the character fields is what has to be looked at. If they're in YYYYMMDD format, then it's most efficient to convert the one date you're examining. However, if they're stored as MM/DD/YYYY, then changing the SET DATE setting is probably going to work best. Haven't tested it though.
>
>Dates stored as characters will always be problematic (especially if there's only 2 digits for the year). I had forgot that DTOC(date,1) was available in 2.6, too.

I believe it pre-dates DTOS(). It was available as far back as FoxBASE+ 2.10 (which was the version I came in on< s >).