Fabio,
I was reading the help file and the CAST Conversion from Character to Datetime is not Full but Partial.
You can get what you want this way:
t=DATETIME()
SET CENTURY OFF
?CAST(m.t AS D)=CAST(CAST(m.t AS C(8)) AS D)
or
t=DATETIME()
SET CENTURY ON
?CAST(m.t AS D)=CAST(CAST(m.t AS C(10)) AS D)
Peter
>Preface:
>If i apply a CAST sequence: CAST(CAST(CAST(...CAST(
>and all the intermediate CAST are
>
F - given Full conversion without loss of >I aspected that the result is the same one of that one obtained making a cast directed only one.
>
>VFP not respect this invariance rule.
>
>Example:
>
>CLEAR
>t=DATETIME()
>? CAST(m.t AS D)=CAST(CAST(m.t AS C(18)) AS D)
>
>? 'DIRECT CAST T -> D' ,CAST(m.t AS D)
>? 'NO LOSS INTERMEDIATE CAST T -> C -> D' ,CAST(CAST(m.t AS C(18)) AS D)
>
>
>Fabio