>Hi everybody,
>
>I tried to convert one output format to another. In the first one the date field is character field 8 and looks like 02/01/00, for example.
>In the second date is date format. In expression builder I tried ctod(date) and it gives me a strange error: "Expression must be of type N", which, of course, confuses me. I assume, that it because of SET STRICTDATE (I just checked it and it set to 1 in this application).
>What should I do? Create a UDF?
Just want to add, that if I just tried in Command window ctod('01/01/00') it gives me 01/01/2000, so works fine. Could it be VFP expression builder bug? I'm using VFP 6.0 SP3.
If it's not broken, fix it until it is.
My Blog