Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. 🙂
Try
Timestamp(Timestamp#(@1,'YYYYMMDDhhmmss')) as DATA,
or
Date(Date#(Left(@1,8),'YYYYMMDD')) as DATA,
or
Date(Floor(Timestamp#(@1,'YYYYMMDDhhmmss'))) as DATA,