Conversion 20221007155001 to date 10/07/2022

[Anonymous]

Hello, everyone,
I wanted to convert the 20221007155001 to 10/07/2022 and used the following command:

Directory;
TAB_tab:

LOAD @1 as question,
Date(Date#(@1,'YYYYMMDD')) as DATA,

FROM
[Y:\Archiv\STATGRAFV4.csv]
(txt, codepage is 28591, no labels, delimiter is ';', msq);

but it gives me no result in the table.
If anyone can help me I would be grateful. 🙂

[hic]

Try
Timestamp(Timestamp#(@1,'YYYYMMDDhhmmss')) as DATA,
or
Date(Date#(Left(@1,8),'YYYYMMDD')) as DATA,
or
Date(Floor(Timestamp#(@1,'YYYYMMDDhhmmss'))) as DATA,