I have such format of date. It contains both date and time(YYYYMMDDHHMMSS).
But I have problem in converting into more applicable format. For Date I found resolution in such command: Date(Date#(left(APP_03,8),'YYYYMMDD'),'DD-MM-YYYY'). Usual DATE command showed me 01.01.9999.
But with time I have problem. When I use the same logic: time(time#(right(APP_03,6),'hhmmss'),'HH:MM:SS'), Insted of 12:19:50, I have 11:53:16. So just randomly incorrect time. When I am using only time#(right(APP_03,6),'hhmmss'), I have correct time 121950, but when I am trying to add separators ":", I have this wrong time.
Also can you advise, how can i write the command to add for all cells with time, 3 hours. In this export I have UTC±00:00 for all data, But it`s necessary to have UTC+03:00