I try to get a datetime format set in a cell.
I have this input (1990.05.15 22:23:15.000000000) from a third party porject.
this gets splited in year, month, day, hour, minute, second, millisecond. Now I try to create a datetime.
DateTime::TryCreate(year, month, day, hour, minute, second, millisecond, dt)
Then I set it to a cell, but the output is this (1990-05-15T20:23:15.000Z) and not datetime.
When I write manually in Excel (1990-05-15 20:23:15.00) I get de-DE (15.05.1990 20:23:15).
Is it possible to convert it, or is there another function which gives me the right format?