How to convert string....('20210228240000' ----> 2021-03-01T00:00:00)
The data should be saved as '20210301000000' but It is stored as '20210228240000' in the SAP.
I try to use 'substr function', but Problems always occur at the end of the month.Finally, as '2021-02-29' is returned, an error occurs in JMP if the date does not exist.Excel recognizes the date automatically...[ = date(2021, 2, 29) ---> 2021-03-01 ]I think...First, cut '20210228' from the record, and con...