This works, too:

NewData = cast( dd || '.' || mm || '.' || yy as DATE);

HTH,
Markus


At 11:37 10.08.2001 +0700, you wrote:

> NewDate = cast( (cast yy as char(4) || '-' || cast mm as char(2) || '-' ||
> cast dd as char(2)) as date);