>No, I did note that you had to convert from character first. :) SUBSTR() would not be needed, and in 2.6 would not provide you anything simpler in getting a date out of it that CTOD() could not do. You'd still need to do CTOD() to get your date format after setting the SET DATE format correctly. In 2.6, there were limityed mechanisms to create date type variables, like CTOD(), {}. So you could do:
>
>cDate = "{"+"01/15/2000"+"}"
>
>dVal = EVAL(cDate)
>
>or
>
>dVal = &cDate

Well, the code was fixed ~2,5 hours ago, so now we're talking just theoretically :)

Anyway, why do I need to use dtos() at all, if I alredy put:

between(CTOD(date),Date1,date2), where DATE is a character field in a table
(yes, FoxPro reserved word and also a char field - sounds stupid)
Date1, Date2 - actual dates, inputted by user.

 If it's not broken, fix it until it is.


My Blog