Conversion 20221007155001 to date 10/07/2022

Anonymous — Sat, 16 Nov 2024 16:46:02 GMT

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. 🙂

Re: Conversion 20221007155001 to date 10/07/2022

hic — Wed, 19 Oct 2022 15:26:53 GMT

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

topic Re: Conversion 20221007155001 to date 10/07/2022 in App Development

Conversion 20221007155001 to date 10/07/2022

Re: Conversion 20221007155001 to date 10/07/2022