>Sure it would, once you're dates were translated from character that is. ;)
>
>>2) Secondly, what DTOS()?
>> I have char field in a table called Date
>> User inputs Date1 and Date2 in a Screen in date format.
>>
>> So, the simplest where clause would be: between(ctod(date),date1,date2)
>
>Works as long the date format matches (possibly not a problem for you). You may also have Y2K issues if the dates don't have 4-digit years stored in the character field.
>
>DTOS() was available in 2.6 (along with DTOC(date,1)), both create a character string from a date type field in the form YYYYMMDD, no matter what the current SET DATE TO format is.

Great, but still doesn't help me. I have a CHARACTER field in a format "01/01/2000" How should I create DTOS() from it?

You would not suggest to use substr, would you? :)