DATA Field Problem

[maben]

I have to convert a db table from (small example):
CREATE TABLE [dataold] (
[id] INTEGER NULL PRIMARY KEY,
[data_txt] TEXT NULL
)

to the table:
CREATE TABLE systems (id INTEGER NOT NULL PRIMARY KEY,date DATE)

I an insert for the migration:
INSERT INTO 'systems' SELECT id, data_txt FROM 'dataold';

The data are stored in the data_txt in the following format DD.MM.YYYY

Everything looked fine but when I looked to the inserted data-fields the new generated data fileds are empty.

I open the database file within an other SQlite Client and all the data items are there ...

What could be wrong?
Thanks for your help!

[Orbmu2k]

Date values must be formated yyyy-MM-dd